Reporting Services report parameter NULL value

Issue: Unable to pass NULL value to the parameter of a report through URL from .NET code.
Solution: In the url add the parameter isNull = true in order to make it accept null value and display the report.
Here is what i had to do, I had a report with 2 parameters. State, Counties.
When I click on a State on the map I wanted to see the report filtered by the selected State and all its counties.
When I click on a county I wanted to see the report filtered by both state and county.
so after creating the report and modifying the dataset as per this article “”
I appended parameter2:isNULL=True when the parameter2 was not passed.
When it was passed, i gave parameter2=value;
Worked like a charm!
Good luck!

GACUtil.exe in Windows Server 2008

I was trying to deploy a custom assembly using Windows 2008 and SQL Server 2008.

I could run as administrator from the command prompt icon and move the .dll file to the assembly folder.

But, the assembly was not installed and could not be listed.

Drag and drop to the folder gave “Access Denied” error.

Tried to look for GACUtil from C:\WINDOWS\Microsoft.NET\Framework\version to install the .dll but the file was missing.

Apparently, the GACUtil.exe utility has now moved first and foremost and is not installed by default until you install the .NET and Windows 2008 SDK.

After that, you’ll be able to find the GACUtil.exe utility in the SDK directory and can call it as shown below:

C:\Program Files\Microsoft SDKs\Windows\v6.1\bin\gacutil.exe /i “dllfilename.dll”

Then, you’ll need to copy your DLL file into the C:\windows\Microsoft.NET\Framework\v2.0.50727 (or whatever .NET version you wish to be on) directory and the custom assembly is ready to be used.

The issue that prompted this learning was that the custom web part deployed could not be added to my SharePoint site and it was throwing the following error.

“Unable to add selected web part(s). A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.”