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 report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
solved Compound PDF report
 Login/Join
 
Platinum Member
posted
I have 2 versions of the same report that i have been asked to incorporate into one. The first report is a summary of advancement giving and pledges. the second is the exact same sat broken out by schools. My user has asked me to incorporate both into one. I created a 2 page document and inserted the summary into the first page and the multi page report into the second page. I have coordinated turned on for the document. below is the code for the composer portion , any ideas?

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.313 0.417), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='HEIGHT: 7.604in; WIDTH: 8.646in; POSITION: absolute; LEFT: 0.313in; Z-INDEX: 1; TOP: 0.417in', $
PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.417 0.458), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='HEIGHT: 7.604in; WIDTH: 8.542in; POSITION: absolute; LEFT: 0.417in; Z-INDEX: 2; TOP: 0.458in', $
END

This message has been edited. Last edited by: Geoff Fish,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Platinum Member
posted Hide Post
The main document was done with document composer I left that out


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Silver Member
posted Hide Post
What isn't working?
How did you want it to look? Should the summary and the detail be on the same page?
Do both versions have the same 1st BY statement? Are you expecting to page-break on this BY statement?


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Msondra:
What isn't working?
How did you want it to look? Should the summary and the detail be on the same page?
Do both versions have the same 1st BY statement? Are you expecting to page-break on this BY statement?



I was told a a by would not work with FML but it does at least on this version. I was trying to use document composer to facilitate this but i am open to other suggestions possiibly somehting that would run one report then then the other and deliver them as one document. I have already tried SET CCOMPOUND OPEN AND CLOSE and that works with excell but the way i have done these reports is as excel within a PDF , it gives amuch cleaner appearance and this is going to the chancellor at some point

I want to display the summary report as the first page followed by the reports for the individual schools. I have a page break in the second report but not the first

summary

TABLE FILE H_ALL
SUM
H_ALL.H_ALL.R_AMT_CY/D20CM AS 'Restricted'
H_ALL.H_ALL.E_AMT_CY/D20CM AS 'Endowment'
H_ALL.H_ALL.U_AMT_CY/D20CM AS 'Unrestricted'
H_ALL.H_ALL.T_AMT_CY/D20CM AS 'Total'
H_ALL.H_ALL.R_AMT_LY/D20CM AS 'Restricted'
H_ALL.H_ALL.E_AMT_LY/D20CM AS 'Endowment'
H_ALL.H_ALL.U_AMT_LY/D20CM AS 'Unrestricted'
H_ALL.H_ALL.T_AMT_LY/D20CM AS 'Total'
FOR
H_ALL.H_ALL.ROWNM
"Gifts and New Commitments (Fundraising Effort)" LABEL R13 OVER
'1' AS 'Gifts' LABEL R14 OVER
'7' AS 'Bequests Realized (unexpected)' LABEL R15 OVER
'3' AS 'Gifts-in-Kind' LABEL R16 OVER
'8' AS 'New Pledges' LABEL R17 OVER
'9' AS 'Revocable Planned Gifts(Face Value)' LABEL R18 OVER
'5' AS 'Irrevocable Planned Gifts(Face Value)' LABEL R19 OVER
" " LABEL R20 OVER
'1' OR '7' OR '3' OR '8' OR '9' OR '5' AS 'Total Gifts and New Commitments' LABEL R21 OVER
" " LABEL R22 OVER
'6' AS 'OSP Grants' LABEL R23 OVER
" " LABEL R24 OVER
'1' OR '7' OR '3' OR '8' OR '9' OR '5' OR '6' AS 'Total Gifts and New Commitments' LABEL R25 OVER
"Outright Giving (VSE Standards)" LABEL R1 OVER
'1' AS 'Gifts' LABEL R2 OVER
'2' AS 'Pledge Payments' LABEL R3 OVER
'3' AS 'Gifts-in-Kind' LABEL R4 OVER
'4' AS 'Bequests Realized (all)' LABEL R5 OVER
'5' AS 'Irrevocable Planned Gifts(Face Value)' LABEL R6 OVER
" " LABEL R7 OVER
'1' OR '2' OR '3' OR '4' OR '5' AS 'Total Outright Giving' LABEL R8 OVER
" " LABEL R9 OVER
'6' AS 'OSP Grants' LABEL R10 OVER
" " LABEL R11 OVER
'1' OR '2' OR '3' OR '4' OR '5' OR '6' AS 'Total Outright Giving with OSP' LABEL R12
HEADING
"Fundraising Activity Report<+0> <+0> <+0> <+0> <+0> "
"Summary Report All Schools<+0> <+0> <+0> <+0> <+0> "
"Through &TEXT_date<+0> <+0> <+0> <+0> <+0> "

detail or second report


SUM
H_ALL.H_ALL.R_AMT_CY/D20CM AS 'Restricted'
H_ALL.H_ALL.E_AMT_CY/D20CM AS 'Endowment'
H_ALL.H_ALL.U_AMT_CY/D20CM AS 'Unrestricted'
H_ALL.H_ALL.T_AMT_CY/D20CM AS 'Total'
H_ALL.H_ALL.R_AMT_LY/D20CM AS 'Restricted'
H_ALL.H_ALL.E_AMT_LY/D20CM AS 'Endowment'
H_ALL.H_ALL.U_AMT_LY/D20CM AS 'Unrestricted'
H_ALL.H_ALL.T_AMT_LY/D20CM AS 'Total'
BY LOWEST H_ALL.H_ALL.STVCOLL_DESC NOPRINT
FOR
H_ALL.H_ALL.ROWNM

This message has been edited. Last edited by: Geoff Fish,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Msondra:
What isn't working?
How did you want it to look? Should the summary and the detail be on the same page?
Do both versions have the same 1st BY statement? Are you expecting to page-break on this BY statement?


I seem to be getting either one report or the other but not both


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Silver Member
posted Hide Post
Hmmm, I haven't tried it with FML.
Have you tried doing it outside the composer with PDF OPEN and PDF CLOSE?

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE CAR
PRINT
SEATS
DEALER_COST
SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

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


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Platinum Member
posted Hide Post
No but that is on my list of things to try .

I was avoiding that because i basically am embedding XLSX already in PDF via Document Composer


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Silver Member
posted Hide Post
I didn't know you could do that. I thought the composer did an override of the format in the reports.

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


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Platinum Member
posted Hide Post
I used your solution Msondra i changed the output to PDF and did not bother with composer at all

set compound = open
set compound = close


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Silver Member
posted Hide Post
Great Geoff, I'm glad you got it to work.


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Platinum Member
posted Hide Post
Yes sometimes old school is still best


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 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     solved Compound PDF report

Copyright © 1996-2020 Information Builders