SQL Server
(1)
Report
(1)
Conger
(1)
Loehle
(1)
Carl
(1)
Dropdownlistof
(1)
Manufactures
(1)
Dropdownlist
(1)

Bypassing parameters in reports

Asked By CarlR
08-Mar-10 08:43 AM
Hi,

I have a report that, before it runs, displays a drop-down list of
parameters for a user to select. Call it Report01.
It would be useful to, from other places, say from Report02, to call
Report01, but to pass it a parameter value. In such a case the dropdown list
should not appear, and Report01 should be rendered from the passed in values.

Is this possible, and if so, any pointers to getting this to work would be
gratefully received.

regards

Carl

Extremely easy and this is how it is design.

Bruce L-C [MVP] replied to CarlR
08-Mar-10 01:41 PM
Extremely easy and this is how it is design. You can use either jump to url
or jump to report. Read up on that in Books Online.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

And yet each time I run the linked to report, it manufactures a dropdownlistof

CarlR replied to Bruce L-C [MVP]
09-Mar-10 04:41 AM
And yet each time I run the linked to report, it manufactures a dropdownlist
of parameters :-(

I had assumed there would be some way to invoke the report and override a
parameter, or the default behaviour would be if a parameter was provided, the
called report should not request any values?

However, perhaps the issue is that I am not providing all the parameters,
and the report's behaviour is show the parameters screen for ALL parameters
even if only one is missing?

Carl

Right, it is now working as expected, erm, by deleting the dropdownlist

CarlR replied to CarlR
09-Mar-10 06:22 AM
Right, it is now working as expected, erm, by deleting the dropdownlist in
Report01, and then by recreating it. Perhaps a typo somewhere on my part?

In any case, the rule seems to be: if parameter is passed in, its used; if
any are neglected, then the report intervenes to collect the value. Excellent!
Post Question To EggHeadCafe