Groups | Blog | Home
all groups > sql server reporting services > april 2005 >

sql server reporting services : new to put the parameter in report


chad
4/6/2005 12:35:05 PM
Have a report with two datasets. One has the list for the parameter
(salesperson_list). The other is a grouped by age / count result that
populates the table in the report.
Age Group Count
0 - 9 2344
10 - 19 588
etc...

How do I put the parameter into the report itself? Such as putting
SalesPerson John Smith
then the results of the dataset.
Probably an easy fix, new to Reporting Services.
John
4/6/2005 1:01:43 PM
="Sales Person " + Parameters!SalesPerson.Value

Put that in a text box. You can do the same in the table or matrix,
but you need to use & to concatenate instead of +.
chad
4/6/2005 1:25:06 PM
It works, but shows the actual parameter ID (ie... 66), rather than showing
the name.
So changed the .Value to .Label and it worked. Thanks for the direction.
Much appreciated. Books don't go deep enough to get into the details of
Reporting Services.

[quoted text, click to view]
AddThis Social Bookmark Button