Displaying Datasource Parameters in Report Body

[Sadie]

I have a report with a parameter set at the datasource level to pull the Top N results from the database.

I would like to be able to display the current value of the Top N datasource parameter in a text box in the body of my report.

Is there a way to do this simply?

i.e.

Datasource Parameter: @topCount

Text Box: Top {@topCount} Records by Total

[Sadie]

i.e.

If @topCount is set to 5, then "Top {@topCount} Records by Total" would display as "Top 5 Records by Total".

[Stef]

Hi Sadie,

Please check the attached video in IE. It illustrates how to configure a SqlDataSource to use parameterized SQL query and how to map SQL parameters to report parameters - SQL Data Source Wizard steps. This approach allows you to display the required information in the report by including the parameter in an expression for a TextBox.Value.


I hope this helps you.

Regards,
Stef
Telerik

 

 

[Sadie]

Thank you so much! The video helped a lot.