I'm using SSRS R8 and have several reports with numerous NUMERIC textboxes. The default NUMBER category that SSRS applies is "Default", which applies no formating to the number values shown in the textbox. When the report executes,
it displays these values with 4 decimal places (e.g. 123.1234). The customer requires 2 decimal places (e.g. 123.12).
This can be easily fixed by changing the category for the NUMBER Text Box Property from "Default" to "Number", with "Decimal Places" set to 2.
The trouble with doing it this way is that each report has over a hundred such textboxes (there are 15 such reports), and to change each textbox individually would be timeconsuming and error prone. The intuitive way to do this would be to select multiple
textboxes that I want to set the NUMBER category for, right click, select Text Box Properties, and set the NUMBER category accordingly. However when I right click the multi-selected text boxes, I see the Text Box Properties option greyed out.
Is there a different way to do this?
View Complete Post