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
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
Quick way to Round all fields
Bertus Botha
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.
biriktirici1
DeDanann
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