sql server reporting services: Missing Resultset -- sql server reporting services

Missing Resultset

Jonas Larsen
8/13/2004 2:57:04 PM

sql server reporting services:

Hi Guys

I have a report where I pass a parameter to a stored procedure that then
returns a resultset to the report.
Everything works well apart from when I choose my *All option. If this *All
option is chosen no data is returned. If run the Dataset and enters the *All
option manually it returns data. If I capture what is sent to the SQLServer
and execute that in Query Analizer it returns data.If I run the report it
comes up empty no errors just no data.
If I run the report with any other option than the *All data is shown the
way it should.

Any Ideas?

Thanks.

Regards
Jonas

Re: Missing Resultset

Jonas Larsen
8/16/2004 8:31:00 AM

Found the error/mistake.

When you have a report parameter and want to use a Stored Procedure (that at
this stage are not able to recieve a parameter) RS automatically creates a
filter.
Once the filter were deleted everything worked.

Jonas
[quoted text, click to view]