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     [Closed] HTML Multiple Reports Styling

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Closed] HTML Multiple Reports Styling
 Login/Join
 
Member
posted
I have a report that has three separate queries and three separate TABLE FILE outputs. I tried to use the compound report feature, but from what I could tell this solution will not help me in this instance. The middle report has a dynamic number of records (1 - 99) and the compound report has a hard coded height defined. If the third report would always follow the end of the second report, then that would work.

Once I scrapped that approach, I resorted to using the HTML format to display the reports, since HTML is designed to be a continuous format. However, the styling of reports 2 and 3 influence the styling of the first report.

Is there a way to specify, perhaps with a -SET command, to reset the styling or prevent the styling to affect the previous data? This is not the case if I use the open nobreak feature for the pdf format.

Also, if the second report can be fluid in a compound report, that would also be helpful.

Thanks in advance.

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


WF 8.2, Dev Studio, DB2, MySQL, self-service
Output formats: HTML, Excel 2000 and PDF
 
Posts: 6 | Registered: July 14, 2010Report This Post
Virtuoso
posted Hide Post
You can change the overflow option of the report to "flowing" in the second report and that should fix the problem.

As for the HTML, it seems there has always been an issue with multiple reports and cascading stylesheets because they apply to the entire content of the page, not just individual reports. Unless you put them each in their own frames, I don't see a way around that problem.

I would stick with a PDF report.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
It may help if you can repro with the IBI supplied files like CAR.


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
Member
posted Hide Post
Here is an example of what is happening if I set it to flowing. The 'height' property seems to take precedence over the 'flowing' feature. The reports end up overlapping. Is there a way around this? Again, the middle report has a dynamic length.


-* File newfex6
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
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='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.521), DIMENSION=(9.996 2.500), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 9.996in; POSITION: absolute; TOP: 0.521in; HEIGHT: 2.5in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 2.313), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 10.004in; POSITION: absolute; TOP: 2.313in; HEIGHT: 4.937in', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.521 4.479), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.521in; OVERFLOW: auto; WIDTH: 9.983in; POSITION: absolute; TOP: 4.479in; HEIGHT: 3.521in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
WHERE COUNTRY EQ 'ENGLAND'
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
END
SET COMPONENT='report3'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
END
COMPOUND END


WF 8.2, Dev Studio, DB2, MySQL, self-service
Output formats: HTML, Excel 2000 and PDF
 
Posts: 6 | Registered: July 14, 2010Report This Post
Silver Member
posted Hide Post
If the Multiple reports you are calling in Composer are Dynamic then better to use PAGELAYOUT feature which avoids overlapping of the reports.
Try this ,
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
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='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.521), DIMENSION=(9.996 2.500), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 9.996in; POSITION: absolute; TOP: 0.521in; HEIGHT: 2.5in', $
PAGELAYOUT=2, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 2.000), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.5in; OVERFLOW: auto; WIDTH: 10.004in; POSITION: absolute; TOP: 2.313in; HEIGHT: 4.937in', $
PAGELAYOUT=3, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.521 2.000), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.521in; OVERFLOW: auto; WIDTH: 9.983in; POSITION: absolute; TOP: 4.479in; HEIGHT: 3.521in', $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
HEADING
"REPORT 1"
WHERE COUNTRY EQ 'ENGLAND'
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
HEADING
"REPORT 2"
END
SET COMPONENT='report3'
-*component_type report
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
HEADING
"REPORT 3"
END
COMPOUND END



Thanks,
Saikumar.


WebFOCUS 8103 Appstudio, Dev Studio MRE
Client Windows 7, Serveron Unix.
Excel, PDF, HTML,AHTML
 
Posts: 38 | Registered: January 24, 2008Report 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     [Closed] HTML Multiple Reports Styling

Copyright © 1996-2020 Information Builders