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  Development Tools  Reporting Services Development  how to dynamically format the text in a textbox?

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-07-27 : 19:15:40 In a matrix report, there are two levels at the horizontal (column) grouping and three levels at the row grouping. I want to format the text of the "aggregate value" of the report depends on the "state" of the column and row grouping. The following is the expression I used for the font color expression: =IIF(InScope("matrix1_Icd9_Code"), IIF(InScope("matrix1_Fiscal_Year"),"DarkBlue","Black"),IIF(InScope("matrix1_Icd9_Desc"), IIF(InScope("matrix1_Fiscal_Year"),"Black","Black"),IIF(InScope("matrix1_Addate_Age_group_1"), IIF(InScope("matrix1_Fiscal_Year"),"Black","Black"),IIF(InScope("matrix1_Addate_Age_group_2"), IIF(InScope("matrix1_Fiscal_Year"),"Black","Black"),"Black")))) and it does NOT work. I want to apply this to other formating like "decoration" and "jump to report" at the Navigation tab. Thanks. Paul Mak