Thursday, February 16, 2012

Can report parameters depends on another parameter?

Hello,
I need my report asks for a field called "work center". The report
must show a drop-down list prompting for it. But first, must prompt
for another field called "enterprise" for showing only the "work
centers" of the selected "enterprise" (selected by another drop-down
list, of course).
I've done three datasets: Enterprises, WorkCenters and MyFinalQuery,
and the report with two parameters, one called "work center" for
filtering MyFinalQuery and another called "enterprise" for filtering
the dataset WorkCenters.
It does not work, it seems that Reporting Services do not allow to do
it.
Can report parameters depends on another parameter?
Thank you.Search Books Online for "cascading parameters"
You must define parameters in certain order. In your case, 1st parameter
must be "enterprise" and 2nd - "work center".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bernat" <bernatfabregat@.yahoo.com> wrote in message
news:7e54e965.0409090659.6a8ac3cd@.posting.google.com...
> Hello,
> I need my report asks for a field called "work center". The report
> must show a drop-down list prompting for it. But first, must prompt
> for another field called "enterprise" for showing only the "work
> centers" of the selected "enterprise" (selected by another drop-down
> list, of course).
> I've done three datasets: Enterprises, WorkCenters and MyFinalQuery,
> and the report with two parameters, one called "work center" for
> filtering MyFinalQuery and another called "enterprise" for filtering
> the dataset WorkCenters.
> It does not work, it seems that Reporting Services do not allow to do
> it.
> Can report parameters depends on another parameter?
> Thank you.|||OK, it works. I tried something similar but wrong (I queried the
dataset of second parameter by filtering - not by where clause).
Thank you very much.

No comments:

Post a Comment