Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [OPINION] Compound Layout - Impressed, and Amazed!, and now disappointed.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[OPINION] Compound Layout - Impressed, and Amazed!, and now disappointed.
 Login/Join
 
Expert
posted
Impressed, and Amazed!

Although there are many things in the compound layout functionality that don't do what I want it to, but...

I just created a 1900 page PDF document from a compound layout of about 5000 components (Over 6000 lines), and it worked.

This message has been edited. Last edited by: Waz,


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Master
posted Hide Post
Yeah,

that works...

But I do miss some functionality.

Like:
A) Setting a parameters while referencing to a existing fex.

example:
TABLE FILE CAR
SUM SALES
BY &CUSTOMBY
ON TABLE PCHOLD FORMAT HTML
END


I like to include this twice in one compound PDF.
Once with &CUSTOMBY = 'COUNTRY'
Once with &CUSTOMBY = 'COUNTRY BY CAR'

It would be really neat to reference to this fex and with a right-click set the parameters for this particular report within the compound.
( yeah it can be done in code, but that's so tricky in a compound pdf )
____________

B) Include compound in compound.
I have a fex that, with compound = open etc. has 3 reports.

This fex can not be included in a compound pdf again. ( in the gui )
Would be nice...
____________

C) Sectionbreaks ?
Sometimes a coordinated compound would be nice.
But usually I need:
1 titlepage
2 recap page
3 a piece with coordination
4 another piece with a different coordination
5 total graph
6 end page.

Would be nice be able to split this in 4 sections. 1+2, 3, 4, 5+6.

( this could also be achieved if you could compound other compounds :-) )
____________

It's not quite there yet. Although I've made some nice clean ready to give to the customers pdf's. But I needed a LOT of seperate fex to get this done.

Greets, D


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Expert
posted Hide Post
Dave, just be creative. I've had 6 graphs on 1 page, DM works fine. Of course, I create 1 via the composer and then code the rest:

  
-* File bi_adv_cash_compound_report
-* Default Mode: ResourceLayout
-DEFAULTS &FMT = 'PDF'
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT &FMT
UNITS=IN, $
OBJECT=bookmarks ,$
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter,  $
PAGELAYOUT=1, NAME='Page layout 1', text='Excelsior Cash Campaign', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report2', TEXT='', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph1',  TEXT='', TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph2',  TEXT='', TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=2, NAME='Page layout 2', text='Fordham College - Rose Hills', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report3', TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report4', TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph3',  TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph4',  TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=3, NAME='Page layout 3', text='Fordham College - Lincoln Center', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report5', TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report6', TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph5',  TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph6',  TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=4, NAME='Page layout 4', text='Gabelli School of Business', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report7', TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report8', TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph7',  TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph8',  TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=5, NAME='Page layout 5', text='Grad School of Arts & Sciences', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report9', TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report10',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph9',  TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph10', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=6, NAME='Page layout 5', text='Grad School of Business Administration', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report11',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report12',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph11', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph12', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=7, NAME='Page layout 5', text='Grad School of Education', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report13',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report14',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph13', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph14', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=8, NAME='Page layout 5', text='GL - Law School', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report15',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report16',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph15', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph16', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=9, NAME='Page layout 5', text='Grad School of Rel & Rel Educ', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report17',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report18',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph17', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph18', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=10,NAME='Page layout 5', text='Grad School of Social Science', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report19',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report20',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph19', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph20', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=11,NAME='Page layout 5', text='Liberal Studies RH & LC', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report21',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report22',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph21', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph22', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=12,NAME='Page layout 5', text='WFUV', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report23',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='report24',TEXT='report2', TOC-LEVEL=0, POSITION=(5.555 0.624), DIMENSION=(5.316 3.753), METADATA='Z-INDEX: 2; LEFT: 4.998in; WIDTH: 5.316in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph23', TEXT='graph1',  TOC-LEVEL=0, POSITION=(0.224 3.586), DIMENSION=(4.169 2.417), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $
COMPONENT='graph24', TEXT='graph2',  TOC-LEVEL=0, POSITION=(5.555 3.586), DIMENSION=(5.316 2.417), METADATA='Z-INDEX: 4; LEFT: 4.995in; WIDTH: 5.316in; POSITION: absolute; TOP: 4.586in; HEIGHT: 3.417in', $

PAGELAYOUT=13,NAME='Page layout 5', text='60M Current Year Campaign', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report25',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph25', TEXT='graph1',  TOC-LEVEL=0, POSITION=(5.555 0.724), DIMENSION=(5.055 2.386), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $

PAGELAYOUT=14,NAME='Page layout 5', text='2.8M Campaign - Athletics', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report26',TEXT='report1', TOC-LEVEL=0, POSITION=(0.224 0.624), DIMENSION=(4.169 3.753), METADATA='Z-INDEX: 1; LEFT: 0.624in; WIDTH: 4.169in; POSITION: absolute; TOP: 0.624in; HEIGHT: 3.753in', $
COMPONENT='graph26', TEXT='graph1',  TOC-LEVEL=0, POSITION=(5.555 0.724), DIMENSION=(5.055 2.386), METADATA='Z-INDEX: 3; LEFT: 0.624in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.581in; HEIGHT: 3.413in', $

END
-*-SET &LOOP = 0;
-*-REPEAT DO_LOOP 2 TIMES
-*-SET &LOOP = &LOOP + 1;
-SET &CATG = 'FU';
-SET &FMT  = '&FMT.EVAL';

SET COMPONENT='report1'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report2'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph1'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph2'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'FC';
-******************************************
SET COMPONENT='report3'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report4'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph3'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph4'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'CL';
-******************************************
SET COMPONENT='report5'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report6'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph5'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph6'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph

-******************************************
-SET &CATG = 'CB';
-******************************************
SET COMPONENT='report7'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report8'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph7'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph8'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GA';
-******************************************
SET COMPONENT='report9'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report10'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph9'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph10'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GB';
-******************************************
SET COMPONENT='report11'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report12'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph11'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph12'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GE';
-******************************************
SET COMPONENT='report13'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report14'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph13'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph14'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GL';
-******************************************
SET COMPONENT='report15'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report16'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph15'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph16'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GR';
-******************************************
SET COMPONENT='report17'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report18'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph17'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph18'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'GS';
-******************************************
SET COMPONENT='report19'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report20'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph19'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph20'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'LS';
-******************************************
SET COMPONENT='report21'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report22'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph21'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph22'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'WF';
-******************************************
SET COMPONENT='report23'
-INCLUDE bi_adv_cash_allyears_report
SET COMPONENT='report24'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph23'
-*component_type graph
-INCLUDE bi_adv_cash_allyears_graph
SET COMPONENT='graph24'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'XX';
-******************************************
SET COMPONENT='report25'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph25'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
-******************************************
-SET &CATG = 'AT';
-******************************************
SET COMPONENT='report26'
-*component_type report
-INCLUDE bi_adv_cash_cur_year_report
SET COMPONENT='graph26'
-*component_type graph
-INCLUDE bi_adv_cash_cur_year_graph
COMPOUND END



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Master
posted Hide Post
Tom,

Ofcourse I had to over simplify the issue using a CAR sample..

But like I said:
quote:
( yeah it can be done in code, but that's so tricky in a compound pdf )


'Them people from IBI' urge us to use the GUI.
So to be able to do this in GUI would be nice.

Thanks.


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Expert
posted Hide Post
Well the compound report I did, could only be done via code, its completely generated in the fex from the data.

I wonder is there is a size limit on the compound layout ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
I support the great functionality Waz mentioned, but would love to find some more documentation.

The drill through gives a lot of nice funtionality.

BTW I hope that nobody will print the 1900 pager of Waz..




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
Actually it will be printed, as its a set of statements to be mailed to investors.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
FYI, there is a limit of 9999 components to a compound layout report.

It worked fine, until it hit the 10000 component, at which time it started to overwrite component 1000.

It also got slower and slower the further the generation got.

Back to the drawing board


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
Waz, with 9999 you are pushing what appears to be a reasonable limit...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Yes you are right, but at lease the limit is known, and if someone else does something as stupid, as what I've just tried, then the answer is here.

Big Grin


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
I'll try to remember this!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Master
posted Hide Post
Waz,

With our 'other' BI-tool I used to generate a lot of PDF's with a loop.
Saved them all in a folder and used an external tool to combine these PDFs to one BIG PDF. Ready to be printed in one job. ( 5000+ pages! )
Thank someone it's no longer printed. They use the PDF's now.

Might be an idea.

You could even automate it. Any PDF landing in some folder get printed automatically.

just a thought...
Greets,D


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
<JG>
posted
for information the documented PDF limits are


Pages
10,000

Images
900

Hyperlinks per page
500

Total pages with hyperlinks
100

Total hyperlinks
44,500
 
Report This Post
Expert
posted Hide Post
Dave, that is what I am doing now, produce each statement separately, then combine them all.


JG, thats good info, I was aware of the 10K page limit, but not the others.

Good One


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [OPINION] Compound Layout - Impressed, and Amazed!, and now disappointed.

Copyright © 1996-2020 Information Builders