Prev: SSRS 2008 working with table of contents
Next: Remove/hide Navigation-Search menu
From: CarlR on 8 Mar 2010 08:43
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
From: Bruce L-C [MVP] on 8 Mar 2010 13:41
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

"CarlR" <CarlR(a)discussions.microsoft.com> wrote in message
news:D75F9552-D0EF-455E-B156-60E0BACA7CE5(a)microsoft.com...
> 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

From: CarlR on 9 Mar 2010 04:41
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

"Bruce L-C [MVP]" wrote:

> 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
>
> "CarlR" <CarlR(a)discussions.microsoft.com> wrote in message
> news:D75F9552-D0EF-455E-B156-60E0BACA7CE5(a)microsoft.com...
> > 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
>
> .
>
From: CarlR on 9 Mar 2010 06:22
Right, it's 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!

"CarlR" wrote:

> 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
>
> "Bruce L-C [MVP]" wrote:
>
> > 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
> >
> > "CarlR" <CarlR(a)discussions.microsoft.com> wrote in message
> > news:D75F9552-D0EF-455E-B156-60E0BACA7CE5(a)microsoft.com...
> > > 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
> >
> > .
> >
 | 
Pages: 1
Prev: SSRS 2008 working with table of contents
Next: Remove/hide Navigation-Search menu