Detail transaction record added twice on a page break

[rich914]

Does anyone know WHY a detail transaction record would be added twice to a group total when that group footer has to print as the first line of the next page?

I have posted questions (written differently) in a couple forums here before. One of the threads just sort of died with no conclusion, the other never generated a response.

Though starting with a blank report and very slowly copying and pasting from the current to the new, I have traced the problem down to this.

The data to the report is similar to an invoice order transaction report. There are multiple child (detail) transactions to the (group) order. Depending on the type of transaction, the amount can be added to one of several different group subtotals.

Have verified that the group subtotal is off by the amount of the last child transaction amount. To test this, I went into the data and changed the amount for this record. The report reflected this.

Any suggestions or comments would be appreciated.

Thanks

Richard

 

[lbass]

Please explain how you are creating the group subtotals and provide specific formulas you are using.

-LB

 

[dtempleton]

Are these the only two tables used in the report? Is thi sdoubling only happening once, or does it happen with other records too?

 

[synapsevampire]

Not much to go on here.

The standard requirements are:

Crystal version
Database used
Example data
Expected output
Post your record selection formula and Database->Show SQL Query, as well as an idea of the report layout and as LB suggests, the method used to build these totals (Crystal summary? Running Total? A formula you've created?

Generic things to try are:

Try applying the service pack.
Turn off the new page before on the group footer, does this still happen?

-k