Displaying Datasource Parameters in Report Body

4 posts, 1 answers
  1. Sadie
    Sadie avatar
    7 posts
    Member since:
    Apr 2015

    Posted 09 Apr 2015 Link to this post

    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

  2. Sadie
    Sadie avatar
    7 posts
    Member since:
    Apr 2015

    Posted 09 Apr 2015 in reply to Sadie Link to this post

    i.e.

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

  3. DevCraft banner
  4. Answer
    Stef
    Admin
    Stef avatar
    3053 posts

    Posted 10 Apr 2015 Link to this post

    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
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  5. Sadie
    Sadie avatar
    7 posts
    Member since:
    Apr 2015

    Posted 10 Apr 2015 in reply to Stef Link to this post

    Thank you so much! The video helped a lot.
Back to Top