Reporting Services Matrix format different between Visual Studio and Report Server

Question

I'm having a problem where in the local project preview tab (and when "running" the report from visual studio) both are corrently formatting. However, after deploying to the report server, the formatting doesn't show through at all for the Row and Column group subtotals.

I'm running Visual Studio 2005.

Example: Col1 Col2 Total RowGroup1 Name1 $20 $15 $35 Item1 $10 $10 Item2 $10 $10 Item3 $15 $15

When Previewing/Running in Visual Studio: the $35 (row & col sub total) has a red background the $10, $10, $15 under the total column has a grey background the $15 (on Item3 row under Col2) has a green background

When running the report from Report Manager (after deploying to the server): the $35 (row & col sub total) has a no background, just white the $10, $10, $15 under the total column has a no background, just white the $15 (on Item3 row under Col2) correctly has a green background.

Any ideas?

Thanks.

Cheers, Catherine

Answer 1

found a work around... http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/d4d21769-2cb0-4bb1-b74b-89e4d31fb724