all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

Passing a null parameter from a report to a subreport


Passing a null parameter from a report to a subreport andrei
4/5/2005 11:38:05 AM
sql server reporting services:
Hi Group,

I have a report with a subreport and I'm trying to make them work in the
report designer in VS2003.
The report has some parameters and one of them is DepartmentIndex, which can
be NULL.
This parameter is being passed down to the subreport.
I set the DepartmentIndex parameter to accept both blank and null values and
gave it a default value of " " (one space),
in both the report and the subreport.
If I run the SUBREPORT alone and check the null checkbox for this parameter,
the subreport works fine and displays the records with a null value in the
DepartmentIndex field.
But if I try to run the REPORT and check the null checkbox, it displays an
error :
An error occurred while executing the subreport '<subreport_name>': One or
more parameters required to run the report have not been specified.

Though, the report data is displayed correctly (showing the rows with null
DepartmentIndex).

Can anybody help, please ?

Thanks,

Andrei.

RE: Passing a null parameter from a report to a subreport Linh Phan
6/3/2005 1:35:10 PM
I got the same error and I would someone can help???

One or more parameters required to run the report have not been specified

Linh

[quoted text, click to view]
Re: Passing a null parameter from a report to a subreport Lev Semenets [MSFT]
6/4/2005 1:59:52 PM
How do you pass parameter into subreport?

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


[quoted text, click to view]

Re: Passing a null parameter from a report to a subreport Linh Phan
6/6/2005 6:09:08 AM
Hi Lev,

I just figured it out by right click on each subreport and set the missing
parameters for each. It worked well.

Thanks!
Linh


[quoted text, click to view]
AddThis Social Bookmark Button