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     <SOLVED>Compound PDF reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
<SOLVED>Compound PDF reports
 Login/Join
 
Rakesh Boddu
Gold member
posted
Hi Guys,

I created compound PDF reports .I am having an issue in it.

I replicated my problem with CAR example.

 -*-------------------Header Report---------
SET COMPOUND = OPEN
TABLE FILE CAR
HEADING
"CAR:<CAR"
" RCOST:<RCOST"
" DCOST:<DCOST"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
-*------------------Detailed Report----------
TABLE FILE CAR
  PRINT 
    RCOST 
    DCOST
  BY CAR 
  ACROSS COUNTRY
  ON TABLE SET BYPANEL ON
  ON TABLE PCHOLD FORMAT PDF CLOSE
END


If i run this i am facing an error

[IMG:left] [/IMG]

If i remove NOBREAK in my first report(Header Report) then i am not getting any error
but i am getting my First report in one page and second report in next page.

I need my second report at the end of my first report.

Can you guys help me.

Valid inputs are highly appreciated.

Thanks in advance.
Rakesh

This message has been edited. Last edited by: Rakesh Boddu,


WebFOCUS 8.0.03
Windows, All Outputs
 
Posts: 59 | Registered: February 13, 2014Report This Post
Waz
Expert
posted Hide Post
The width of one of the report components is wider that the PDF page.

This is not allowed when you use NOBREAK.

You need to either change the size of the PDF layout to a larger one or reduce the with, by changing the styling, say font size, etc


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
Rakesh Boddu
Gold member
posted Hide Post
Thanks Waz for very quick response.

I cannot change width ,i cannot make it static.
The ACROSS columns are dynamic.

Is there any other way to bring my second report to the end of first report.

Thanks,
Rakesh


WebFOCUS 8.0.03
Windows, All Outputs
 
Posts: 59 | Registered: February 13, 2014Report This Post
Anatess
Guru
posted Hide Post
You cannot have the 2nd report in a compound no-break report not fit in the pagesize of the first report... it just is not logical.

Here, this should work for you:

TABLE FILE CAR
HEADING
"CAR:" RCOST:" DCOST:ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END
-*------------------Detailed Report----------
TABLE FILE CAR
PRINT
RCOST
DCOST
BY CAR
ACROSS COUNTRY
ON TABLE SET BYPANEL ON
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='LETTER',ORIENTATION=LANDSCAPE,SIZE=8,$
ENDSTYLE
END

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


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
How dynamic is the across ?

What is the maximum number of values ?

When designing a report these are the sorts of things that need to be considered.

You can change the PAGESIZE and ORIENTATION, as we Anatess' example.

Page Size can be quite large, but ends up very small.

Another option is to use a coordinated compound report, this way you can have multiple reports handing the across parts.


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
Rakesh Boddu
Gold member
posted Hide Post
Hi Waz and Anatess,

Thanks for replies.Great

Instead of using Compund PDF,i joined my SQL's and i am using just PDF report.

Thanks,
Rakesh


WebFOCUS 8.0.03
Windows, All Outputs
 
Posts: 59 | Registered: February 13, 2014Report 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     <SOLVED>Compound PDF reports

Copyright © 1996-2020 Information Builders