December 31, 2007, 01:57 AM
focuzsambitPage-Break...
Can we do a page-break not on each (PIN) but for every 2 (PIN).
--------------------------------------------
The syntax for first is given below:
BY PIN NOPRINT PAGE-BREAK
--------------------------------------------
tks/sam
December 31, 2007, 04:26 AM
FrankDutchyes
Create a dummy field PIN2 that changes every two PIN and do the page-break on that field.
January 01, 2008, 07:01 PM
susannahlike Amsterdam Frank says,
say you want to do something every 5th...
-SET &MYVALUE = 5 ;
...
if its page-break, you have to make your key a BY field , so you need to do a define *AFTER* have your file in the print order you want
KEY/I1=IF LAST KEY IS &MYVALUE THEN 1 ELSE 1+LAST KEY ; NOPRINT
KEY2/I1=IF KEY GT LAST KEY THEN KEY2 ELSE ABS( 1 - LAST KEY2 ); NOPRINT
BY KEY2 NOPRINT PAGE-BREAK
If its conditional styling, its easier, you don't need the right order first, you can compute:
COMPUTE KEY/I1=IF LAST KEY IS &MYVALUE THEN 1 ELSE 1+LAST KEY ; NOPRINT
COMPUTE KEY2/I1=IF KEY GT LAST KEY THEN KEY2 ELSE ABS( 1 - LAST KEY2 ); NOPRINT
BY PIN
..
TYPE=DATA , BACKCOLOR=&RGBSMOG, WHEN=KEY2 EQ 1,$
January 02, 2008, 08:58 PM
PiipsterThis seems to work on R714 in Windows. Use BY TOTAL on your COMPUTEd field.
TABLE FILE EMPDATA
HEADING
"*************************************************************"
"Page <TABPAGENO </1"
PRINT FIRSTNAME LASTNAME
COMPUTE PINCTR/I2 = IF LAST PINCTR EQ 2 THEN 1 ELSE LAST PINCTR +1;
COMPUTE PB/I2 = IF PINCTR EQ 1 THEN LAST PB +1 ELSE LAST PB;
BY TOTAL PB PAGE-BREAK
BY PIN
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
I would expect it would work on other platforms as well.