Hi,
Does anyone know how to do this ? I need to create a multi-tier parameter
entry screen for a reporting service project.
For example, I have one dropdown box - the user selects an item and that
Item will deterimine what is in a different list box, then the user can
select multiple items from the listbox to run the report.
I have no problem creating a custom ASPX page but I dont know how to
inegrate it into the report server, I would like the main report menu to
still be able to access this report ( and send it to the custom param page)
Any ideas on how to solve this problem ? I would like to avoid creating my
own custom report menu page if possible.
Thanks,
--
Dave GI don't know what you want exactly but from what I understand here is my
solution.
From your first parameter, make a new DataSet for the values in your second
parameter. Make a DataSet parameter that contains the report parameter
value. Then, in your second parameter, take values from With request and
select your DataSet.
If your values for the parameters aren't in your database then I don't see
how to do it unless you make an Expression to set your values in the second
parameter. You then have to verify the first parameter if it is the good
one. If yes then show the value. If not return Nothing.
I hope this will help you!
"Dave G" wrote:
> Hi,
> Does anyone know how to do this ? I need to create a multi-tier parameter
> entry screen for a reporting service project.
> For example, I have one dropdown box - the user selects an item and that
> Item will deterimine what is in a different list box, then the user can
> select multiple items from the listbox to run the report.
> I have no problem creating a custom ASPX page but I dont know how to
> inegrate it into the report server, I would like the main report menu to
> still be able to access this report ( and send it to the custom param page)
> Any ideas on how to solve this problem ? I would like to avoid creating my
> own custom report menu page if possible.
> Thanks,
> --
> Dave G|||What you are describing is called cascading parameters. RS supports this.
Search books on line for the phrase cascading parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave G" <DaveG@.discussions.microsoft.com> wrote in message
news:70C8C6F5-E011-4098-9A90-22E72BB0C562@.microsoft.com...
> Hi,
> Does anyone know how to do this ? I need to create a multi-tier parameter
> entry screen for a reporting service project.
> For example, I have one dropdown box - the user selects an item and that
> Item will deterimine what is in a different list box, then the user can
> select multiple items from the listbox to run the report.
> I have no problem creating a custom ASPX page but I dont know how to
> inegrate it into the report server, I would like the main report menu to
> still be able to access this report ( and send it to the custom param
> page)
> Any ideas on how to solve this problem ? I would like to avoid creating my
> own custom report menu page if possible.
> Thanks,
> --
> Dave G
Sunday, March 11, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment