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] Compound report where user gets the opion of HTML, Excel or PDF

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Compound report where user gets the opion of HTML, Excel or PDF
 Login/Join
 
Latigresa
Platinum Member
posted
I have a report that has two reports due to what the user wants to see. I'm able to get the report to display correctly when I select HTML but when I select PDF or Excel I only see the 1st report. Please any and all help is greatly appreciated! Smiler

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


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
fatboyjim
Platinum Member
posted Hide Post
Hi,

You will need to make PDF and EXCEL to be compound reports.

Best Regards,

Jimmy Pang


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
Latigresa
Platinum Member
posted Hide Post
This is my first time working with compound reports. How do I make them compound? Thank you.


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
Latigresa
Platinum Member
posted Hide Post
I left out an important part. The user gets all three options. I'm using a parameter for the format.


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
fatboyjim
Platinum Member
posted Hide Post
You can take a look at the following page as an example for PDF.

http://documentation.informati...r26_pagelayout13.htm

It should be the same for excel as well.

I'm assuming that you have a variable that determines the format. Then you can add the OPEN and CLOSE keywords only for PDF and EXCEL format.

Hope that helps.

Best Regards,

Jimmy Pang


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
Latigresa
Platinum Member
posted Hide Post
Ok...I was able to get both of the reports to show up but they are displaying on seperate pages instead of one after the other. I'm a littlw closer. I used the ON TABLE SET COMPOUND OPEN NOBREAK on the first report and CLOSED on the 2nd report.


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
fatboyjim
Platinum Member
posted Hide Post
It might be depending on the report size that may not fit in one page. You may need to resize the reports (example from link)


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
Latigresa
Platinum Member
posted Hide Post
They are both like 10 lines at the most.


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
fatboyjim
Platinum Member
posted Hide Post
Hi,

Below are two ways to get the compound report to display in one page (approx 10 lines). And they seem to be working.

1) Directly into the ON TABLE HOLD
  
-* File compound.fex
-*SET COMPOUND='OPEN NOBREAK'
TABLE FILE EMPDATA
PRINT
     DIV
     DEPT
     SALARY
WHERE RECORDLIMIT EQ 10
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
-*ON TABLE PCHOLD FORMAT PDF
HEADING
"EMPDATA"
END

-*SET COMPOUND=CLOSE 					
TABLE FILE EMPLOYEE
PRINT
     DEPARTMENT
     LAST_NAME
     FIRST_NAME
WHERE RECORDLIMIT EQ 10
ON TABLE PCHOLD FORMAT PDF CLOSE
-*ON TABLE PCHOLD FORMAT PDF
HEADING
"EMPLOYEE"
END


2) Using the SET command
  
-* File compound.fex
SET COMPOUND='OPEN NOBREAK'
TABLE FILE EMPDATA
PRINT
     DIV
     DEPT
     SALARY
WHERE RECORDLIMIT EQ 10
-*ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
ON TABLE PCHOLD FORMAT PDF
HEADING
"EMPDATA"
END

SET COMPOUND=CLOSE 					
TABLE FILE EMPLOYEE
PRINT
     DEPARTMENT
     LAST_NAME
     FIRST_NAME
WHERE RECORDLIMIT EQ 10
-*ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE PCHOLD FORMAT PDF
HEADING
"EMPLOYEE"
END


Best Regards,

Jimmy Pang

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


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 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] Compound report where user gets the opion of HTML, Excel or PDF

Copyright © 1996-2020 Information Builders