passing report parameters -- sql server reporting services

dalem
1/8/2005 8:59:02 PM

i have one report (A) that calls another report (B) based on a parameter i
pass. Form B has it's filter set to the report parameter passed. everything
works ok.

what i want to do is call the same report B from another report that it
would show all of the records for the dataset without the filter taking
effect. is there a way to do this.

thanks

Bruce L-C [MVP]
1/9/2005 2:46:34 PM

You can pass the wildcard for the filter. If I remember correctly the
wildcard for the filter is *, try passing that.

Note that filters in general are dangerous, they bring all data over and
then apply the filter. In most cases you are better off to use a query
parameter instead.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

sql server reporting services : passing report parameters