Multiple Sub-Summary Parts

[Donkick]

I'm printing a report with Sub-Summary parts in the layout. I would like to have a summary of the subsummary parts, the same way a trailing grand summary would work except multiple occurances on a page.

Example:

Office Supplies 25.00

Internet Provider 50.00

Phone 30.00

TOTAL EXPENSES 105.00

Sales 200.00

Subscriptions 75.00

TOTAL INCOME 275.00

I suppose I could use a Trailing Grand summary and print each one on a seperate page, but is there a way to do this all on one page?

[John Mark Osborne]

Have you tried a trailing subsummary part rather than a leading? This trailing subsummary part will have to be sorted by a field that has the same value on all the records you want to summarize. For instance, it looks like in your example you have expenses and sales. Add a trailing subsummary part sorted by this field.

[Donkick]

Do you mean a sub-summary part that appears above rather than below the records that it summarizes?

I guess my example was a little vague... I am trying to replicate a summary report similar to one in quickbooks.

it would actually be something like this:

software 50.00 (a summary)

pencils 10.00 (a summary)

TOTAL OFFICE SUPPLIES 60.00 (a sub-summary )

phone 50.00 (a summary)

cell phone 50.00 (a summary)

TOTAL PHONE 100.00 (a sub-summary )

TOTAL EXPENSES 160.00 (a sub-summary of a sub-summary)

Sales 150.00 (a summary )

Subscriptions 15.00 (a summary )

TOTAL INCOME 165.00 (a sub-summary )

NET PROFIT 5.00 (a sub-summary of a sub-summary)

I might be able to do it with multiple portals on a layout?

[John Mark Osborne]

The problem with using portals is it makes the report less flexible. Relationships disregard found sets so you have to build everything into the relationship. With a subsummary report, you can change the report with a simple find.

Anyhow, I decided the best way to show how to do what you want is to create an example file.

SSREPORT.fp7.zip

[Donkick]

Mark,that it so slick! Thanks for taking the time to make that great file.

There is no way I would have gotten that without the file. I didn't even know you could have a layout without a "body" part.

I use your Scriptology book as well.

Thanks!