Prev: SSRS 2008 get report parameters to work
Next: IIS hangs when accessing SQL Reports
From: childofthe1980s on 1 Apr 2010 12:43
Hello:

I am creating a receivables aging report. The end user will choose, through
a drop-down list, to run the report for periods of either "30-days" or
"90-days", depending on which of these two choices he makes in that drop-down
list.

I know that a drop-down list will need to pull from a parameter. Now, the
only parameters that I have created ever in SQL reporting services are those
that pull from one dataset and, therefore, usually just that one table.

But, the 30-days data will come from one table, while the 90-days table will
come from another. No other parameters or selections are to be made in this
report by the user, until the user decides whether to choose 30 or 90 days.

That being said, (a) is it possible to create a "primary" parameter that
will run before the user makes selections in other "secondary" parameters and
(b) can a parameter be created that will choose one dataset (table) over
another dataset (table) depending on what the user wants to choose (i.e. 30
vs. 90)?

childofthe1980s
 | 
Pages: 1
Prev: SSRS 2008 get report parameters to work
Next: IIS hangs when accessing SQL Reports