Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Column and Row group text color in ssrs 2008 in matrix

Traitée Column and Row group text color in ssrs 2008 in matrix

  • Monday, December 03, 2012 8:13 PM
     
     
    Sign In to Vote
    0

    im asking in ssrs 2008 is there any text color expression.i mean i want to change the text color for my column groups or row groups  when run the report,in most of site i only see the background color which sometimes not look good to view, i think change the text color will do.

    here is my table  when run the report ..if Animal(cat and dog) is my column group and person1and 2  is my row group, all i want how can i make to different text color for my column group when run the report eg cat 1 = red and dog 1 =blue..even if possible if row group has different color

    mouse cat  dog
    person1  1   12
    person2  3    4

    thanks in advance


    • Edited by uttar007 Monday, December 03, 2012 9:12 PM
    •  
     

All Replies

  • Monday, December 03, 2012 9:15 PM
     
     
    Sign In to Vote
    0
    The text color is simply "Color" in the Font section of the properties pane. It, like backgroundcolor, supports expressions.

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

     
  • Monday, December 03, 2012 9:40 PM
     
     
    Sign In to Vote
    0

    hi Tim

    thanks for your reply but still not solves my problem

    if my column group is something like this =Fields!XXX.value...when i run the report the cat and dog display separate, this applies for my row group too.

    if i change the text "color" in property to "green", run the report it will still be green...

    thanks

     
  • Tuesday, December 04, 2012 8:30 AM
    Moderator
     
     Answered
    Sign In to Vote
    3

    Hi Uttar,

    From you description, you want to set the background color base on the category and number of the animal, right? Please try to use the expression below to set the background color of the
    =switch(fields!category.Value="cat" AND fields!number.Value>5,"Red",
                fields! category.Value="cat" AND fields! number.Value<=5,"Green",
                fields! category.Value="dog" AND fields! number.Value>5,"Blue",
                fields! category.Value="dog" AND fields! number.Value<=5,"Yellow")
    I have tested this expression, the results looks like:

    If this is not you want,you can set the background color you want manually in Excel, then provide us the screenshot about the sample result, so that we can make further analysis.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Tuesday, December 04, 2012 6:09 PM
     
     
    Sign In to Vote
    0
    Or set Color as Charlie describes above to change the text color.

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

     
  • Monday, December 10, 2012 2:44 AM
     
     
    Sign In to Vote
    0

    hi

    thanks..:)

     
  • Monday, April 08, 2013 12:12 PM
     
     
    Sign In to Vote
    0

    Hi Lio,

    If i need only highlight text value,so how to do this.

    example like :

    SharePoint 2010

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS