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?
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
October 26, 2016, 09:55 AM
Geoff Fish
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.ROWNMThis message has been edited. Last edited by: Geoff Fish,
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
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 ENDThis message has been edited. Last edited by: Msondra,
WebFOCUS 8.1.05 Windows, All Outputs
October 26, 2016, 01:15 PM
Geoff Fish
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
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
October 26, 2016, 04:52 PM
Geoff Fish
I used your solution Msondra i changed the output to PDF and did not bother with composer at all