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)
 matrix - format one column only

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-10-25 : 05:12:36
There is a matrix in the report with dynamic columns. i.e. column1, column2, column3, etc...
The values are all formatted in the textbox properties to show % infront of the figures.
All the numbers under each column show as % figures.
How can I make sure the numbers under column say column 3 only show as numbers and not with % figures?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 05:23:21
are all columns including column 3 under same column group scope?

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

Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-10-25 : 07:35:09
Solved. Thanks.
Added an iif expression to the textbox.
Go to Top of Page
   

- Advertisement -