Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Parameters Selected Shown in Report and/or Footer Expand / Collapse
Author
Message
Posted Saturday, January 12, 2013 4:17 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:46 AM
Points: 158, Visits: 504
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.



Post #1406420
Posted Saturday, January 12, 2013 5:13 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
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
Post #1406430
Posted Saturday, January 12, 2013 6:05 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:46 AM
Points: 158, Visits: 504
Thank you, I'll give it a go and let you know how i get on.

Thanks again.

Post #1406434
Posted Saturday, January 12, 2013 6:15 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:46 AM
Points: 158, Visits: 504
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
Post #1406435
Posted Saturday, January 12, 2013 9:22 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
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
Post #1406443
Posted Monday, January 14, 2013 7:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 9:50 AM
Points: 38, Visits: 109
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, ", ")
Post #1406722
Posted Tuesday, January 15, 2013 6:21 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:46 AM
Points: 158, Visits: 504
many thanks
Post #1407223
Posted Tuesday, January 15, 2013 8:58 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
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
Post #1407316
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse