Custom colors on categories in Web Report Studio reports

0

Conditional formatting for numeric values is pretty simple for users in Web Report Studio, but how about colors on categorical values - such as customer name, product type, issue severity etc. (This was requested from a WRS user in the SAS Discussion Forums)

Turns out this can be done, however it's a little tricky.
1. You will need to define the values within the data table itself.
Such as changing Region = 'Canada' to Region = Canada
Note & possible best practice: This could be done in a reference table and joined to the actual table within the relationship tab of Information Map Studio.

2. In Information Map Studio, select the data item's properties, move to the 'Classification, Aggregations and Formats' tab and check the box next to 'Display as a hyperlink'. This tells SAS to allow all the tags to go through to the displayed WRS report.

Here is an example of the final results:

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top