sql server reporting services: passing null report parameter via a url -- sql server reporting services

passing null report parameter via a url

collie
1/9/2005 4:17:01 AM

sql server reporting services: Hi,

I have a SP in sql with parameters that can get null values such as:
@paramguf tinyint=null,
AS
select 1 as kodKibuz,name
from learningstuds
where
(@paramguf is null or hasamaguf=@paramguf)

I am sending the report parameters via vb.net

Dim URL As String
URL =
"http://localhost/reportserver/reports/tutorials?%2fTutorials%2fKibuzKlita1"
URL += "&rs:Command=render&rc:Parameters=false&rc:Toolbar=false"
URL += "&paramdate=" + Date32.saveDate().ToShortDateString
URL += "&paramguf=" + ddlGuf.SelectedValue

'Pass the URL as a Web request
'Dim request As HttpWebRequest = WebRequest.Create(URL)
Response.Redirect(URL)

How can I send a null value to the report for paramguf?

Thanks

Re: passing null report parameter via a url

Lev Semenets [MSFT]
1/9/2005 6:16:29 PM

quoting KB article http://support.microsoft.com/kb/842853

You can also pass a null value for a parameter to a report by adding
'param:isnull=true' to the URL. For example, if the SalesOrderNumber is a
Null-valued report parameter that must be passed to the report, add the
'SalesOrderNumber:isnull=true' string to the URL."

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]