Tuesday, March 20, 2012

Quick way to Round all fields

I am having to go through each of my fields in my table to edit and put Round() around them. Is there a quick way to do this instead of having to edit every textbox?

You can round them in SQL query.

select ROUND(col, ...) from t

here is the syntax: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_93z8.asp

|||I am doing heavy calculations in SSRS, not SQL. The calcs I'm doing you wouldn't want to do in SQL, it would hurt your brain and take a century to finish. Basically I'm doing 4 complicated excel spreadsheets in SSRS|||

So you want to Round values in textboxes, not the field values coming from DB? Then yes, you need to change expression in every textbox.

No comments:

Post a Comment