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     Compund report in PDF format

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Compund report in PDF format
 Login/Join
 
Member
posted
Hy,

I have I problem with a compound report in PDF format. Each part of the compound report is posted on a page like this:
page 1 - report 1
page 2 - report 2
page 3 - report 3

Is it possible to obtain this compound report on a single page ?
For example when I use the Excel format I have something like

'ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK' but for PDF I can't use NOBREAK.
I wonder if there is a similar syntax.

Thanks in advance for your answers.


WF 5.3.3 platform Windows, database:Oracle
 
Posts: 6 | Registered: March 06, 2007Report This Post
Expert
posted Hide Post
You can definitely use NOBREAK for PDF compound reports:

-* Report 1 ----------------------------

SET PAGE-NUM=OFF
TABLE FILE CAR
  SUM SALES/D10
  BY COUNTRY
  BY CAR

  HEADING
  "1 - Sales Report"
  " "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=RED, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END
-RUN

-* Report 2 ----------------------------

TABLE FILE CAR
  SUM DEALER_COST
  BY COUNTRY
  BY MODEL

  HEADING
  "2 - Inventory Report"
  " "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=BLUE, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
-RUN

-* Report 3 ----------------------------

TABLE FILE CAR
  SUM BODYTYPE
  BY COUNTRY
  BY BODYTYPE NOPRINT

  HEADING
  "3 - Body Type Report"
  " "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=GREEN, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF CLOSE
END
-RUN

This message has been edited. Last edited by: Francis Mariani,


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
Virtuoso
posted Hide Post
Angel

Welcome here, please update your personal signature with some version information so we all know what you are using.

The answer from Francis is the basic on.
Depending on your version there might be other ways to solve this.
One is the PDF layout painter which give you the possibility to "paint" your report with a header, logo, and put the various report components including graphics on the paper as you like it.




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
Member
posted Hide Post
Hello again,

I'm using WF 5.3.3.
I tried again to use NOBREAK for PDF but I got the same strange result:each report has an independent orientation
My compound report looks like this
||
||
=
where each || is a report.

And also I can't 'paint' my report because there are a lot of labels, conditional instructions.
I can only made it by hand Sweating

Thanks,

Mady


WF 5.3.3 platform Windows, database:Oracle
 
Posts: 6 | Registered: March 06, 2007Report This Post
Gold member
posted Hide Post
Hi

Use FOCFIRSTPAGE to set the page And Compound Command To Open And Close Compound Report
Here is the example


SET FOCFIRSTPAGE = &FOCNEXTPAGE
SET COMPOUND = OPEN

-* Report 2 ----------------------------
TABLE FILE CAR
SUM SALES/D10
BY COUNTRY
BY CAR

HEADING
"1 - Sales Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=RED, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

-* Report 2 ----------------------------
SET FOCFIRSTPAGE = &FOCNEXTPAGE
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
BY MODEL

HEADING
"2 - Inventory Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=BLUE, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

-* Report 3 ----------------------------
SET FOCFIRSTPAGE = &FOCNEXTPAGE
TABLE FILE CAR
SUM BODYTYPE
BY COUNTRY
BY BODYTYPE NOPRINT

HEADING
"3 - Body Type Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=GREEN, $
TYPE=HEADING, SIZE=12, $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN
SET COMPOUND = CLOSE




Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF
 
Posts: 52 | Location: NJ,USA | Registered: May 26, 2004Report This Post
Virtuoso
posted Hide Post
Aren't you gonna need a NOBREAK in there somewhere?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Angel, please try running the code I posted. If it works, there may be something small in your stylesheet that needs to be tweaked. If my code does not work, then there could be a bug or some other issue.

Alternative code:

SET PAGE-NUM=OFF

-* Report 1 ----------------------------

SET COMPOUND = OPEN
-RUN

TABLE FILE CAR
SUM SALES/D10
BY COUNTRY
BY CAR

HEADING
"1 - Sales Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=RED, $
TYPE=HEADING, SIZE=11, STYLE=BOLD,$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
-RUN

-* Report 2 ----------------------------

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
BY MODEL

HEADING
"2 - Inventory Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=BLUE, $
TYPE=HEADING, SIZE=11, STYLE=BOLD,$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
-RUN

-* Report 3 ----------------------------

SET COMPOUND = CLOSE
-RUN

TABLE FILE CAR
SUM BODYTYPE
BY COUNTRY
BY BODYTYPE NOPRINT

HEADING
"3 - Body Type Report"
" "
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='Arial', COLOR=GREEN, $
TYPE=HEADING, SIZE=11, STYLE=BOLD,$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END
-RUN

(wf1998, your example does not use NOBREAK, which is the objective of this post, and page numbering was not mentioned as an issue).

Cheers.

This message has been edited. Last edited by: Francis Mariani,


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
Member
posted Hide Post
And now the final post about this problem:

I wanna thank you for your answers. The code posted by mr. Francis worked just fine so I started to study the stylesheet and I found a small but ugly bug about orientation.

Mady, The Angel Smiler


WF 5.3.3 platform Windows, database:Oracle
 
Posts: 6 | Registered: March 06, 2007Report This Post
Expert
posted Hide Post
So, you're not really an angel, then?


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
Member
posted Hide Post
Sometimes I am Music


WF 5.3.3 platform Windows, database:Oracle
 
Posts: 6 | Registered: March 06, 2007Report This Post
Expert
posted Hide Post
Bucket of cold water for Francis please Wink
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
Nice one, Tony. Good One

I think this thread has strayed from the original question. Red Face

Time to put this one to rest. Big Grin


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
Whaa?


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Compund report in PDF format

Copyright © 1996-2020 Information Builders