August 17, 2009 at 6:21 am
Hi
I have a report in SSRS 2005, where i need to toggle between single and multivalued parameters. I should have 2 options 'SINGLE' and 'MULTI', based on them i need to toggle the parameters type.
I don't find this feature in SSRS. I heard that this may be possible using .NET code. Please tell me how can we achieve this? Please Help!!!
Thanks
August 17, 2009 at 6:44 am
Hi, are the reports getting data from a cube or from tables in a db?
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 17, 2009 at 6:46 am
No, I am querying a SQL Server 2005 Database, not SSAS cube.
Thanks
August 17, 2009 at 7:38 am
I'm not really sure. But I'm thinking this is a web dev thing. I think (but I'm probably wrong) that you'd need to create 2 reports, exactly the same but 1 accepts single value parameters and then the other multi value parameters. If a user selects 'SINGLE' then the website refers them directly to the correct report, and vice versa.
🙁 I wish I could have been of more help. I hope that their is a better solution out there than what I'm thinking of. It'll be interesting to find out!
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
August 17, 2009 at 8:54 am
Hi William
Thanks for your response.
It looks, its a bit complicated issue and not in the scope of SSRS. May be we can do it using .net but not sure how.:-)
As you said i can do it by creating 2 reports one for single valued and other for multi valued parameters, but i am looking for a solution where i can do it in a single report.
Lets see if any SSRS expert may answer this luckily.
Thanks for your time.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply