I created a line items report and all was great, until I went back to add a field, now my report is not subsummarizing how I created it with the report wizard. I didn't change any of my page breaks, so why did my report go from calculating my subsummary totals, to not showing any totals and listing all the records one after another? The field I added was in the header and not in the body..not only that, but another report began doing the same thing and I didn't even touch that one, If you change a layout does it affect your other layouts as well??? All ideas are welcome...thank you!!

Summary reports only display correctly when the records are sorted correctly -- by the "break" fields on the summary layout.

It sounds like you have not sorted the records.

I tried re-sorting the records, but still can not get back to the original report that I created. The totals are all in the wrong places and it doesn't seem to be page breaking where it should. By re-sorting the data, does this affect my other layouts as well, because another report is acting this same way and I have not touched that one? Any other ideas.....thanx!!

I figured out my sorting, but now the report does not show any totals, except the grand total at the end. It is showing all the records, kind of like a list. I tried all different modes, but it still lists all the records. It should be calculating a total per month per customer number, then page breaking to the next customer number. Changing the sort method does change my other layout, is there a way to keep my other layout different?

Perhaps you can post a clone of your problem file, or maybe a screenshot of the layout in layout mode, with the part names extended.

I believe I have figured out my sorting problems. I kept sorting all different ways and have become very comfortable with the results. I don't need a whole separate layout for my other report, all I have to do is resort the data according to that report. I do have one more question although, where is the best place to put the totals? Right now I have my item total in the Trailing Grand Summary part, I don't know why, but that is the only way I can get it to show up correctly on my report. If I have a regular Total field and a Grand Summary (one above the other) the Total field does not show up correctly in find and browse mode. Any suggestions? Thanks for all the feedback though, you helped me with my sorting problem :0)

Are you looking for running totals for your subsummaries? If so, make sure your summary field is a Running Total, otherwise, make sure it's not.

How do I change it to a running total? I can't seem to access that option..will a running total show up at the end of every invoice or is it like a grand total at the very end of all the invoices?

To change to a running total, go to Define Fields, find and select the summary field you're changing, click options and look for a checkbox for Running Total. (At least that's how you do it on a Mac)

A running total will show up in each summary occurence, and it will always take the last total and add the amount from the summary in which it's displayed. If you're doing this with invoices, you would NOT want a running total, otherwise the running total would include previous invoices (assuming you're doing a subsummary for all invoices).

Perhaps you could explain what, exactly, you're trying to show on your report or else post a clone of your database?