January 12, 2013 at 4:17 pm
Hi, I'm reasonably new to Reporting Services and still learning so A) bear with me and B) please excuse any misuse of terminology and C) sorry if i come across as a bit of a novice.
I'm using SQL Server Business Intelligence Development Studio for my reports.
They are linked to views we have built in a Data Warehouse.
We are designing the reports using something my boss calls "cascading queries". Basically the first parameter chosen filters the data , then the second parameter options available are only those within the previous parameter selection. Third parameter options based on 1 and 2 etc etc. Then we apply.
My question is as follows....?
Some of my reports have 5 or 6 parameter options and so the end user struggles to remember what they have chosen once the report is printed out. Is there a way of showing in either the report or the footer the parameters the user has chosen in order to run their specific report?
Many thanks in advance for any advice given.
January 12, 2013 at 5:13 pm
Yes you can do that.
It sounds like you use drop boxes for each parameter. In the properties there is a label field. I add that Parameter label to a text box in the header of the report when I do something like this.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2013 at 6:05 pm
Thank you, I'll give it a go and let you know how i get on.
Thanks again.
January 12, 2013 at 6:15 pm
hi,
I've had a look, where exactly is the properties you are refering to. i have looked at both the parameter and the sub parameter dataset properties. i cannot see a label ????
thanks in advance
January 12, 2013 at 9:22 pm
In parameter properties, go to available values. You set the label on this screen.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 14, 2013 at 7:29 am
In the text box enter something like this in the expression:
Parameter!.YourParameterName.Label or Parameter!.YourParameterName.Value
If you allow the user to select multiple parameters you can use the Join function:
Join(Parameter!.YourParameterName.Lavel, ", ")
January 15, 2013 at 6:21 am
many thanks
January 15, 2013 at 8:58 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply