Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts

Friday, March 23, 2012

how can I bold the text in the sumtotal panel

I have a matrix report with sumtotal.

I can change the font color etc' in the sumTotal title, but I want to change the color in the values that it not seem like the regular data with no success.

here the report that i talking about

(the black row is the sumTotal)


Hi,

From your description, it seems that you want to modify the value's color in your report, right?
If so, I think you can achieve that by using the expressions. You can design a report so that different styles are applied to items based on the data in the report. For example, you can display negative numbers in red or change the background colors on a table.

To make styles conditional, use an expression instead of a static value for the style properties of the item. For example, to make a text box render negative values in red for a field called Profit, open the Properties Window and use the following expression in the Color property:

For font:
=Iif(Fields!TotalDue.Value < 10000,"Red","Black")
For background color:
=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")

For more information, see
http://technet.microsoft.com/en-us/library/ms156400.aspx
http://technet.microsoft.com/en-us/library/ms159238.aspx

Thanks.

Wednesday, March 21, 2012

how can i add heading in Matrix Report for columns and rows

How can i add a column heading for coulumns and row heading for rows in Matrix report created by wizard. i m using vs 2005 ..You need to create a Row Group or Column Group but at least from my perspective I have always stayed from Matrix's in MS RS and the reason why is - I cannot control the extrapolation of the matrix to the defined width of my report - probably a lousy reason - but I "fake" out based on a regular table layout a matrix look and feel with drill through's...
If the user wants to see everything then "click" and everything will be displayed - but for the first panel of data I provide as much possible releavant info and you want to see more then click on a link and I will navigate you to eternity! Also, when I navigate I keep the primary data field they clicked on as a parm and display this in the subsequent (called module) so the have a "path" of wheer they started there "infinite journey" from!
Best regards,