Report Parameters Selected Shown in Report and/or Footer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Report Parameters Selected Shown in Report...

Report Parameters Selected Shown in Report and/or Footer

Rate Topic

Display Mode

Topic Options

Author

Message

LoosinMaMind

Posted Saturday, January 12, 2013 4:17 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:36 AM
Points: 140, Visits: 424

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

SQLRNNR

Posted Saturday, January 12, 2013 5:13 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1406430

LoosinMaMind

Posted Saturday, January 12, 2013 6:05 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:36 AM
Points: 140, Visits: 424

Thank you, I'll give it a go and let you know how i get on.

Thanks again.

Post #1406434

LoosinMaMind

Posted Saturday, January 12, 2013 6:15 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:36 AM
Points: 140, Visits: 424

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

SQLRNNR

Posted Saturday, January 12, 2013 9:22 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

In parameter properties, go to available values. You set the label on this screen.

Post #1406443

tommy.neustupa

Posted Monday, January 14, 2013 7:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 1:12 PM
Points: 2, Visits: 39

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

LoosinMaMind

Posted Tuesday, January 15, 2013 6:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:36 AM
Points: 140, Visits: 424

many thanks

Post #1407223

SQLRNNR

Posted Tuesday, January 15, 2013 8:58 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

You're welcome.

Post #1407316

« Prev Topic | Next Topic »

Permissions