Friday, February 17, 2012

Drilldown in parameter pick lists.

Is it possible to get drilldown functionallity in a parameter pick
list?
So that it is possible to expand/collapse items just like in e.g pivot
table?
Like:
+ All Time
- 2000
- Jan
- Feb
- Mar
etc
- 2001
- Jan
- Feb
- Mar
etcHi,
No, you need to expand all the values in a single query for drop down. May
be you can have two parameters
one for year and second for month. or otherwise list all the year and
months in one query.
Amarnath
"Jan" wrote:
> Is it possible to get drilldown functionallity in a parameter pick
> list?
> So that it is possible to expand/collapse items just like in e.g pivot
> table?
> Like:
> + All Time
> - 2000
> - Jan
> - Feb
> - Mar
> etc
> - 2001
> - Jan
> - Feb
> - Mar
> etc
>|||Ok, thanks.
But it would had been a great feature though :-)|||If you really need that functionality, you can always roll your own asp.net
page with your server controls the way you want, then set up the selection or
button click event to call the report and pass in the parameters to the
ReportServer via URL api, or web service.
--
Regards,
"Jan" wrote:
> Is it possible to get drilldown functionallity in a parameter pick
> list?
> So that it is possible to expand/collapse items just like in e.g pivot
> table?
> Like:
> + All Time
> - 2000
> - Jan
> - Feb
> - Mar
> etc
> - 2001
> - Jan
> - Feb
> - Mar
> etc
>

No comments:

Post a Comment