Wednesday, March 28, 2012

new to put the parameter in report

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.
Thanks="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 +.|||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.
"John" wrote:
> ="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 +.
>

No comments:

Post a Comment