Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Formatting multiple fields in SSRS 2008 R2

Author  Topic 

SunnyDee
Yak Posting Veteran

79 Posts

Posted - 2012-08-14 : 10:54:04
Is there a way to format multiple fields at the same time.

It appears that you can format multiple fields in SSRS, but I can only format the alignment, height, width.

I need to format many fields for currency or numeric. Is there a shortcut that I am missing?

Thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-14 : 13:04:35
you can so far as format expression is the same

select multiple textboxes pressing ctrl key and click properties icon from top menu

then set the required expression for format property

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

SunnyDee
Yak Posting Veteran

79 Posts

Posted - 2012-08-16 : 10:41:53
I see where you can make formatting changes such as font and alignment... I don't see where you can select multiple text boxes and format the text box properties - number format.

I would like to select multiple text boxes and format all of them to currency. I don't see this option in SSRS. Is it not available?
Go to Top of Page
   

- Advertisement -