Substituting the result of a scalar result into a string.

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

    Posted 18 Oct 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
    Admin
    Todor avatar
    6 posts

    Posted 20 Oct 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.

    Regards,
    Todor
    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