Friday, November 23, 2012 3:16 PM
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?
- Edited by dev-13 Friday, November 23, 2012 3:18 PM
Friday, December 14, 2012 4:35 PMModerator
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."
Wednesday, January 02, 2013 3:27 AM
You could create a large nested switch statement for each conditional color for each cell...
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"
- Proposed As Answer by Dusty of BI Goals Wednesday, January 02, 2013 3:27 AM
Wednesday, January 02, 2013 3:41 PM
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!