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,

The main document was done with document composer I left that out

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?

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,

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

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,

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,

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

Great Geoff, I'm glad you got it to work.

Yes sometimes old school is still best