This is a migrated thread and some comments may be shown as answers.

Substituting the result of a scalar result into a string.

1 Answer 18 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
rwb
Top achievements
Rank 2
rwb asked on 18 Oct 2017, 09:08 AM

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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 20 Oct 2017, 02:25 PM
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
Tags
Report Designer (standalone)
Asked by
rwb
Top achievements
Rank 2
Answers by
Todor
Telerik team
Share this question
or