Help - Need to have Multiple Table Summaries in Report

[txblueeyes]

Well, I have varied Files that relate to each other, and some have summary fields in tables, that I want the summary to show up in a high level report... Each Table houses various information that I have Summaries, and varied calculations.

I create the layout/Report from the Main Table, I of course can get any information I want on the report from that table, including the relationalship data (in the body).. however, when I add the summary fields from the related table into the sub-summary and grand summary, the related table Grand Trailing Summaries are never correct, it will just give the last summary amount, not the entire summary amount I even tried some portals, and created some special Sum Calculations, however, the summaries from the main table are always correct, it's the related table summaries that aren't... I even tried doing calculated fields to pull the summary data from the related table, then created a summary to feed of that field... works to s point... so any suggestions??...

I am also in the process of migrating into Pro 8, and Pro 8 Server when we receive the upgrade.. Have I just had a bad case of "SOS", Stuck on Stupid .....

Edited October 2, 2005 by Guest

[Mike D.]

txblueeyes,

First, welcome to the forums!

You didn't give us an idea of how your report is structured. From your description, I'm guessing that you only have one subsummary on your layout along with a grand and grand trailing summary.

For your report, multiple subsummaries may be needed. Multiple subsummaries on a report are not uncommon and they would be organized in a top down order. You would have a high level subsummary followed by a detailed subsummary. Each subsummary has to be sorted by the key field associated with the data you want reported on that level.

The more you tell us more about your report structure, the better we can help you.

HTH, Mike