http://www.sqlservercentral.com/blogs/sql_awesomesauce/2010/08/13/tip_3A00_-change-multiple-field-formats-in-ssrs/

Printed 2014/10/20 04:59AM

Tip: Change Multiple Field Formats in SSRS

By Jen McCown, 2010/08/13

One of the things about SSRS that irritates me is that in the graphical editor, you have to set the text box properties (say, to format numbers as currency) for each individual text box…unlike Excel, where you can select multiple fields, hit CTRL-1 and format them all at once.

Here’s a better way (with some restrictions) to update the formatting for multiple text boxes.  Let’s say we’re making a grid 12 columns across, and it contains mostly currency data. Instead of right-clicking every box, let’s do this:

<Value>=Fields!Year1_Assets.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Format>’$'#,0;(‘$’#,0)</Format>
</Style>
</TextRun>

It’s a workaround, sure. But it beats the hell out of the several-steps right-click process we were doing before. Happy reporting!

-Jen McCown

http://www.MidnightDBA.com/Jen


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.