How to format all numbers in a detail row

[Andrew King]

I am converting an old application to WPF and I am looking
at the various report viewer options. The back end database provides the summarized
data in table format and all number fields are float types. Each row of number
values of the table needs to be displayed it a different format; row 1 is the
summed values (scientific notation), row 2 is the limit or goal (fixed decimal),
and row 3 is the decimal percentage of goal/limit (fixed decimal percent) and this
pattern repeats. SSRS provides an expression to format numbers for the entire
detail row of the tablix. I am looking for a similar solution in Telerik’s
report designer or is there a better method of doing this that I am
overlooking?

And thanks for a native WPF report viewer
control.

[Stef]

Hello Andrew,

You can change the format of the TextBox items in a row via expression. For example select all TextBox items in a row and in the Property Grid add a Binding to their Format property. the expression can use any of the built-in functions (Conditional and Data functions) and available data fields to add the needed logic for the format.

About the WPF ReportViewer, please check the following articles when you start working on it:

• How to: Add report viewer to a WPF application - soon will be updated with the specifics of the new implicit styling;
• Setting a Theme (Using Implicit Styles) - note that Telerik.windows.Controls XAML files should be updated according to the referenced version of the UI for WPF.

I hope this information helps you.

Regards,
Stef
Telerik

[Andrew King]

Works great! Thanks.