formula field executing twice for 1st record on 2nd page

[donagins]

I have a sub-report that sits in a group footer on the main report. The subreport contains a formula field that increments a grand total. The subreport report header is empty, but when I "hide" it or change it's size, the formula field is executed twice for the first occurrence of the subreport on the second page (and I assume for subsequent pages also, but there are only two).

The formula is in the subreport's report footer. I've also tried it in the header, but got the same results.

Changing the size of the subreport header makes the formula run twice for a record different than before (a different record lands as 1st on the 2nd page), so I'm convinced it has something to do with the page break, and not the data.

I've tried both "keep together" options, but get the same results.

The detail and summary data from the subreport appears as it should, and it not duplicated. Only the formula runs twice, and only for that 1st occurrence on the 2nd page.

Has anyone ever seen anything like this?

Thanks,
Don

Crystal Version 10.0.0.533

 

[dgillz]

Do you have your group footers repeated on every page?

Do you want to increment for every page or for every group?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[donagins]

dgillz -

I have the main report detail suppressed - the report detail is produced by the subreport that is in the group footer. I don't see an option for "repat group footers", but the "repat group headers" is turned off.

I'm incrementing by the sum from the subreport, so it's for every group.

Since my first post, I removed the other two sub-reports from the section, and I can't reproduce the problem. I checked the other subreports multiple times, and they looked OK. I was going to add the other subreports to the 1st subreport, I can't put a subreport in a subreport, so I'm still stuck.

Thanks,
Don

 

[donagins]

I thing I've got it -

I divided the group footer into 3 sections, one for each subreport, and it appears to be working consistently. I can't get the data lined up side-by-side, but at this point, I'm OK with that.

 

[lbass]

Try formatting two of the sections to "underlay following sections" to get the desired horizontal layout.

-LB