Is there anyway to place a compound report after a BY field. Using the below example, I would want the compound report to appear on the page everytime the TYPE changes.

ex TABLE FILE CAR
BY TYPE
BY MAKE
ACROSS MODEL
SUM DOLLAR_VALUE
END

I am already able to put the compound report at the very end, but I need for a summary to appear after the first BY statement.

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

I'm not sure what you're asking. It sounds like the end result is just to start a new page of the report everytime the TYPE changes. Something like this?

TABLE FILE CAR
BY TYPE PAGE-BREAK
BY MODEL
SUM DCOST
ON TABLE SET PAGE OFF
ON TABLE PCHOLD FORMAT PDF
END

I'm having trouble visualizing what you need as well. There isn't really a way to insert a report into the middle of a report (without some pretty complicated trickery!)

You might want to try a coordinated compound report, which allows you to have a complete compound document for each value of the BY field.

Could it be that this is a classic case of misunderstanding?
What the forum members usually think about when the term 'compound' is used is a set of different and possibly related reports that are being grouped into one document.
It might also mean that the question here is about (sub)totals and or subfoots.

If so, just use the ON TYPE SUBTOTAL phrase.

I'll try to be clearer in this post. What I want is a coordinated compound report for each BY field. How do I make REPORT 2 appear following the conclusion of the BY change. The affects would be equivalent to a sub-total on a by statement. I want to use the same concept with COMPOUND reports as the data is apples and oranges. I know that the syntax is as follows
--- REPORT 1---
TABLE FILE CAR
..
..
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
END
----REPORT 2 --- APPEARS AFTER EVERY BY
TABLE FILE CAR
..
..
ON TABLE PCHOLD FORMAT PDF NOBREAK
END
----REPORT 3 --- APPEARS AT THE END OF THE REPORT
TABLE FILE CAR
..
..
ON TABLE PCHOLD FORMAT PDF CLOSE
END

----REPORT 1-------
TYPE MODEL DCOST1 DCOST2 DCOST3 DCOST4
HONDA CRX $25,000 $23,000 $23,000 $21,000
HONDA ACCORD $26,909 $25,000 $20,000 $12,000
TOTAL HONDA $51,909 $48,000 $43,000 $33,000

----REPORT 2 ----- The below report would appears after the first BY change.
HONDA VEH $51,909 $48,000 $43,000 $33,000
5 MILES @ 2.5% 1,298 1,200 1,075 825
4 MILES @ 1.2% 623 576 516 396
3 MILES @ 3.3% 1,713 1,584 1,419 1,089

----BY CHANGE --REPORT 1-------
TYPE MODEL DCOST1 DCOST2 DCOST3 DCOST4
NISSAN MAXIMA $25,000 $23,000 $23,000 $21,000
NISSAN ALTIMA $26,909 $25,000 $20,000 $12,000
TOTAL NISAN $51,909 $48,000 $43,000 $33,000

----REPORT 2 ------- The below report appears after the first BY change.
NISSAN VEH $51,909 $48,000 $43,000 $33,000
5 MILES @ 2.5% 1,298 1,200 1,075 825
4 MILES @ 1.2% 623 576 516 396
3 MILES @ 3.3% 1,713 1,584 1,419 1,089

------REPORT 3 ------- AT THE END OF THE REPORT, ANOTHER COMPOUND REPORT APPEARS THIS REPORT WOULD APPEAR AFTER ALL THE BY FIELDS AT THE END OF THE REPORT.

DELIVERY COST
NISSAN MAXIMA
COST 103,818 103,818
RATE 1.2% 1.2%
RATE COST 1,246 1,426
TOTAL COST 105,064 105,064

Hopefully this is alot clearer.

As Darin said, there is no easy standard out of the box way to do this.
Reports are fairly single-minded things, they do not really allow for something else to be put in between records of the same report.

Looks to me that MACGYVER is the way to go.

From what you've shown, it looks like the data in your REPORT2 that appears at the end of each sort break could be calculated with COMPUTE statements amd then inserted using a ON byfield SUBFOOT, thus eliminating the need for a separate report. But it still has the appearance of a report within a report Then you could just add the final report using the compound report syntax.

Also, as a note, the syntax you use cannot be used for a coordinated compound report. That is the older syntax for creating a compound report, but use of the coordination functionality requires the new syntax as contained in the documentation. You don't show your software versions or platforms (please add them to your profile) so we can't tell if you would even have this functionality.

Probably best alternative option is to read and hold all your possible BY field values and then create a Dialogue Manager loop to read each value, one at a time, and generate all the necessary reports, adding your final report at the end.

I agree with Darin, I think if you check out RECAP and SUBFOOT you will be able to accomplish the desired effect.

Also, consider the use of the NOBREAK option for your PCHOLD FORMAT PDF line, IF you do the DM looping and IF you want the looped reports to be continuous... Try it with and without the NOBREAK and see what works best for you...