|
I'm using PROC REPORT and ODS EXCELXP tagset with SPANROWS. I'm having a
problem with coloring alternate rows.
proc report data=custexpired split='*' spanrows ;
column rowvar keyring label enddt sn cn flagit ;
define rowvar / group noprint ;
define flagit / computed noprint ;
define keyring / group 'Keyring' ;
define label / order 'Key Label' ;
define enddt / display format=mmddyy10. 'Expires' ;
define sn / order 'Serial*Number' ;
define cn / order 'Common*Name' ;
* color every other row light blue)
compute rowvar ;
if mod(rowvar,2) = 0 then do ;
call define(_row_,'style',
'style={background=cxccffff}') ;
end;
endcomp;
My report looks like:
------------------------------------------+
| Keyring |Key Label|Expires|Serial Number|. . . .
+---------+---------+-------+-------------+
| | Label1 |12/31 | 13 | <-- white
| +---------+-------+-------------+
| Keyring1| Label2 |11/01 | 13 | <-- white
| (white) +---------+-------+-------------+
| | Label3 |10/12 | 0 | <-- white
+---------+---------+-------+-------------+
| | Labela |09/15 | 14 | <-- Blue
| +---------+-------+-------------+
| keyring2| Labelb |07/01 | 14 | <-- white
| (blue) +---------+-------+-------------+
| | Labelc |06/05 | 12 | <-- white
+---------+---------+-------+-------------+
I want it to look like:
------------------------------------------+
| Keyring |Key Label|Expires|Serial Number|. . . .
+---------+---------+-------+-------------+
| | Label1 |12/31 | 13 | <-- white
| +---------+-------+-------------+
| Keyring1| Label2 |11/01 | 13 | <-- white
| (white) +---------+-------+-------------+
| | Label3 |10/12 | 0 | <-- white
+---------+---------+-------+-------------+
| | Labela |09/15 | 14 | <-- BLUE
| +---------+-------+-------------+
| keyring2| Labelb |07/01 | 14 | <-- BLUE
| (blue) +---------+-------+-------------+
| | Labelc |06/05 | 12 | <-- BLUE
+---------+---------+-------+-------------+
Any guidance is appreciated!
| 
