Round to a certain decimal point

[Austin]

Hey guys, I was wondering if there is a expression to round to a certain decimal point(EG. 11.9789 -> $11.98). I know with SQL reporting there is a Round(number,2) which solved this problem. 

Any help would be appreciated. Thanks

[IvanY]

Hi Austin,

You can easily format the display of the number in a textbox by using the Format property in the property grid.

If you need to round your number when you are using it in expression you have two options - round it in the sql query or write your own user function that will return the rounded number. For more information about user functions please check this help article.

Kind regards,
IvanY
the Telerik team

[Divya]

cross tab report by passing parameters in dynamic parameters through design after clicking the button then show the report like below

[Stef]

Hello Divya,

If your question is related to rounding numbers, this is my post in your support ticket on the same topic:

"The Round built-in function expects only one parameter and returns the nearest Integer number. If you need to format(round) a number to a specific place in it, you can use the TextBox.Format property and specify a Number format through the Format Builder Dialog.

You can use also user function and implement custom logic to round and format the value of the item."

About configuring data retrieval methods with parameters mapped to report, parameters, please check for instance the steps in the SqlDataSource Wizard help article. Note that the Design Time values are used just to retrieve the data scheme, and the actually passed values are those set for the corresponding report parameters.

Regards,
Stef
Telerik