Focal Point
[CLOSED] Insert blank rows after particular value

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8437001036

April 11, 2013, 06:58 AM
Sourabh Mukherjee
[CLOSED] Insert blank rows after particular value
I want to insert blank line in reports after particular row value

category sales
wood 1000
asst 2000
dddd 1111

the outpu required is
wood 1000
asst 2000

dddd 1111

can't achieve it through skip-line, because space after each sort group is not required.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Windows, All Outputs
April 11, 2013, 07:20 AM
Arunkumar
Hi,
The below example code may help you in getting blank line after a particular row.

 
TABLE FILE CAR
SUM
DEALER_COST AS 'Dealer Cost'
RETAIL_COST AS 'Retail Cost'  
AND COMPUTE ROWCNT/I9 = LAST ROWCNT + 1; 
AND COMPUTE ROWCNT12/I9 = IF ROWCNT LE 5 THEN 1 ELSE 2; 
BY TOTAL ROWCNT12 NOPRINT
BY CAR
ON ROWCNT12 SUBFOOT
" "
END 


Thank you.
Arun