Hi
how to give Alternate Two colurs to record
This is my code
for "Total No Of Records" also to be change the colur
can any one help me plz...
DEFINE FILE CAR
DUMMY/I1 = '';
END
TABLE FILE CAR
SUM
BODYTYPE
SEATS
DEALER_COST
COMPUTE ROWS/I5 = LAST ROWS + 1; NOPRINT
BY DUMMY NOPRINT
BY CAR
ON DUMMY SUBFOOT
"Total No OF Records :<TOT.ROWS"
ON TABLE PCHOLD FORMAT EXL2K
END
This is output i need
http://www.sumopaint.com/myimages/?s=huge&p=1[/IMG]
This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
November 04, 2011, 09:32 AM
njsden
You do that through a style sheet definition.
...
ON TABLE SET STYLE *
TYPE=DATA, BACKCOLOR=(WHITE SILVER), $
ENDSTYLE
...
i tried with that but i want to be apply Color Dynamic for "Total No Of Records"
how to do can any one help me plz
WebFOCUS 7.6 Windows, All Outputs
November 06, 2011, 03:39 PM
Waz
Here is one way, using njsden's suggestion, and conditional styling on the subfoot.
DEFINE FILE CAR
DUMMY/I1 = '';
END
TABLE FILE CAR
SUM COMPUTE TOT_COL/A1 = IF IMOD(CNT.CAR,2,'I1') EQ 0 THEN 'Y' ELSE 'S' ;
SUM
BODYTYPE
SEATS
DEALER_COST
COMPUTE ROWS/I5 = LAST ROWS + 1; NOPRINT
BY DUMMY NOPRINT
BY CAR
ON DUMMY SUBFOOT
"Total No OF Records :<TOT.ROWS"
ON TABLE SET STYLE *
TYPE=DATA, BACKCOLOR=(YELLOW SILVER), $
TYPE=SUBFOOT, BACKCOLOR=YELLOW, WHEN=TOT_COL EQ 'Y', $
TYPE=SUBFOOT, BACKCOLOR=SILVER, WHEN=TOT_COL EQ 'S', $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
But if your report is more complex, the calc will also be more complex.