Substituting the result of a scalar result into a string.

2 posts, 0 answers
  1. rwb
    rwb avatar
    37 posts
    Member since:
    Aug 2015

    Posted 18 Oct 2017 Link to this post

    I'd like to have a text box containing something like

    <code>There are {suppliers} suppliers.</code>

    and have <code>{suppliers}</code> substituted with the result of a query such as

    <code>SELECT COUNT(*) FROM Supplier</code>.


    Is this possible? How?

  2. Todor
    Todor avatar
    520 posts

    Posted 20 Oct 2017 Link to this post

    Hello rwb,

    In some report items (including TextBox) properties values you can use embedded expressions, as described here.

    You can also use expressions as values in report item properties, as described in this help article.

    Note that in the expressions you can use the built-in functions, or user functions. For details concerning user functions, see Extending Expressions article.

    In the attached report I have demonstrated both approaches - look in the TextBoxes in the page footer section.

    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top