Focal Point
Page-Break...

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

December 31, 2007, 01:57 AM
focuzsambit
Page-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


WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
December 31, 2007, 04:26 AM
FrankDutch
yes

Create a dummy field PIN2 that changes every two PIN and do the page-break on that field.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 01, 2008, 07:01 PM
susannah
like 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,$




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 02, 2008, 08:58 PM
Piipster
This 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.


ttfn, kp


Access to most releases from R52x, on multiple platforms.