 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Repeat Row In Every PDF Page | Login/Join |
| Member |
Dear All, Is there a way to print out the same row per PDF page by using PAGE-BREAK? I will use the CAR table to show what I illustrate what I mean. Let's say we have to following data: CAR CTR JAGUAR 1 JENSEN 2 DATSUN 3 MASERATI 1 TOYOTA 2 AUDI 3 TRIUMPH 1 ALFA ROMEO 2 BMW 3 PEUGEOT 1 How can I manipulate the holding table to be something like: CAR CTR XXXXXX 0 JAGUAR 1 JENSEN 2 DATSUN 3 XXXXXX 0 MASERATI 1 TOYOTA 2 AUDI 3 XXXXXX 0 TRIUMPH 1 ALFA ROMEO 2 BMW 3 XXXXXX 0 PEUGEOT 1 I can then basically use the PAGE-BREAK function so each PDF page will display the XXXXX value therefore PAGE 1 will consist XXXXXX 0 JAGUAR 1 JENSEN 2 DATSUN 3 PAGE 2 will consist XXXXXX 0 MASERATI 1 TOYOTA 2 AUDI 3 PAGE 3 will consist XXXXXX 0 TRIUMPH 1 ALFA ROMEO 2 BMW 3 And Page 4 will consist XXXXXX 0 PEUGEOT 1 Any suggestion would be much appreciated. Thanks in advance WebFOCUS 767 Server 64bit On Windows 2003 Server WebFOCUS 767 Server for Developer Studio On windows XP | ||
|
| Master |
Define a field and put it in a heading. DEFINE FILE CAR HDFLD/A12='XXXXXXXX'; HDFLD2/D12=0; END TABLE FILE CAR HEADING "<HDFLD <DHFLD2" SUM CTR.CAR BY CAR END Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Member |
Thanks for the reply PBrightwell. Sorry but I forgot to mention, it has to be a row in the data. WebFOCUS 767 Server 64bit On Windows 2003 Server WebFOCUS 767 Server for Developer Studio On windows XP | |||
|
| Expert |
Obviously you'll have to "invent" the data. You could use McGyver or you could filedef the output file using append and then table your main data into followed (or preceded) by your invented data - FILEDEF BHS6868 DISK BHS6868.FTM (APPEND
-RUN
TABLE FILE CAR
SUM COMPUTE CAR/A16 = 'XXXXXX';
COMPUTE CNTR/I3 = 0;
BY COUNTRY
ON TABLE HOLD AS BHS6868 FORMAT ALPHA
END
TABLE FILE CAR
SUM COMPUTE CNTR/I3 = IF COUNTRY EQ LAST COUNTRY THEN CNTR + 1 ELSE 1;
BY COUNTRY
BY CAR
ON TABLE SAVE AS BHS6868
END
-RUN
TABLE FILE BHS6868
PRINT CAR CNTR
BY COUNTRY NOPRINT PAGE-BREAK
BY CNTR NOPRINT
ENDT
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |