display parameters in the report 2

[akalinowski]

i am heavily using SSRS now and everyone loves it except the accounting department, they like to see the report parameters on the report itself when printed and/or exported to excel

the data is OK but i am not sure how to include what was selected for example date range or product category or store (retail company)



akalinowski

http://www.olivelabs.com

 

[RiverGuy]

Put a TextBox on the top of the report. In the expression, put something like the following:

="Date Range:  " & FORMAT(Paramters!StartDate.Value, "MM/dd/yyyy") & " through " & FORMAT(Paramters!EndDate.Value, "MM/dd/yyyy")

 

[akalinowski]

gave that a shot but it errors out that !FromDate is not defined.

akalinowski

http://www.olivelabs.com

 

[xlbo]

Is that what your parameter is called or what it is laballed?

If you use the expression editor, you should be able to just open up the paramters colleciton and double click the appropriate one to insert it...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[akalinowski]

ha figured it out i needed to put them in single quotes to specify text.

computers, they dont do what you want them to they do what you ask them to


thanks for your help that was the answer.

akalinowski

http://www.olivelabs.com