topic Re: Color Coding with STP? in Developers

Color Coding with STP?

ross_geller — Wed, 04 Nov 2009 09:35:52 GMT

Hi all.
I'm working on a project based on customized reporting.
We use WebReportStudio on SAS 9.1.3 (actually migration to SAS 9.2 is coming), and often Java Flexi web appl to customize masks.

The purpose is that the Customer asked to use Color Coding on some tables in order to identify a best/worse item in the table, which means that the rule is:
- Cell Value =>MEDIA+10 get green color,
- Cell Value < MEDIA-10 get red color)
The problem is that the trend, so that the rule of the color coding, changes trend based on a Threshold, as follows:
IF CellValue<=Threshold then
- Cell Value =>MEDIA+10 get green color,
- Cell Value < MEDIA-10 get red color)
IF CellValue>Threshold then
- Cell Value =>MEDIA+10 get red color,
- Cell Value < MEDIA-10 get green color)

The developer team's proposal is to add to the table an added column with the check, but in my opinion the report could become too heavy and laboured.

So i ask if it's possible to get solution by means of STP.

Thanks for attention and in advance for response.

Cheers
-g.

Re: Color Coding with STP?

Vince_SAS — Wed, 04 Nov 2009 13:14:43 GMT

Maybe PROC REPORT with a COMPUTE block to set the style attributes?

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000545547.htm

Vince DelGobbo
SAS R&D

Re: Color Coding with STP?

ross_geller — Thu, 05 Nov 2009 17:14:04 GMT

Thanks Vincenzo.
By use of ODS and COMPUTE we can get reports .pdf, .html, .xls, etc.
but we would like to keep on browsing olap cubes, WebReportStudio-like.

In that case, it seems WRS does not give the chance to implement a complex condition to format table's cells (see the above example formula)

Cheers
-giuseppe