Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Complex SSRS Report with different formats and drill through reports

Vorgeschlagene Antwort Complex SSRS Report with different formats and drill through reports

  • Friday, November 23, 2012 3:16 PM
     
     
    Sign In to Vote
    0

    Hi

    I am producing a report which looks at different indicators which all have different targets.

    I need to display the data using a background fill colour to see if they are meeting target every month (simple iif statment in the background colour property)

    Is there a way to put the data into the tablix as normal and apply colour if I have about 100 diffrernt indicators and targets so each row in the tablix relates to their own background colour target e.g. one row might have a target of 10, another row may have a target of 3000.

    Currently I have developed a prototype which has a query for each tablix.  I also need to add in a chart for each tablix now.  I feel that I am now going to have far too many reports and charts as I am having to do one per query and it is defeating the object of the software.

    Is there any way for me to achieve this without all the the duplication, or do you think this is the only way for me to achieve my goal?

    Would a tablix filter achieve this?

    Thanks


    • Edited by dev-13 Friday, November 23, 2012 3:18 PM
    •  
     

All Replies

  • Friday, December 14, 2012 4:35 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    From a support perspective this is really beyond what we can do here in the forums. If you cannot determine your answer here or on your own, consider opening an Advisory Services case with us. Visit this link to see the various support options that are available to better meet your needs:  http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone."

    Thanks,

    Cathy Miller

     
  • Wednesday, January 02, 2013 3:27 AM
     
     Proposed
    Sign In to Vote
    0

    You could create a large nested switch statement for each conditional color for each cell...

    =Switch(
      Fields!Sys_State.Value = "Active"   , "Black"
    , Fields!Sys_State.Value = "Deleted"  , "Yellow"
    , Fields!Sys_State.Value = "Resolved" , "Green"
    , Fields!Sys_State.Value = "Closed"   , "Red"
    , Fields!Sys_State.Value = "Complete" , "Blue"
    )

    Dusty

     
  • Wednesday, January 02, 2013 3:41 PM
     
     
    Sign In to Vote
    0

    hi,

    you can either write a code/function to accept the target value and then return the specific color that you want based on the value using case statements. Alternatively, if you have that many, I would suggest to build a small table in your database that has the value,color as fields and then link  this to your dataset and use the color value from the table to set the row fill color.

    As for the chart in each tablix, try adding a sub-report inside the tablix.

    Hope this helps!