September 5, 200619 yr 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?
September 5, 200619 yr 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.
September 6, 200619 yr Author 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?
September 6, 200619 yr 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
September 7, 200619 yr Author 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!
Create an account or sign in to comment