Substituting the result of a scalar result into a string.

[rwb]

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?

[Todor]

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