I got the answer through a Crystal Developer forum. The answer was to turn off the "Keep Together" option in the group expert settings. I had already turned it off in the section expert but didn't know that the option also exists in the group expert.
Carolyn,
It's a long complicated story, but bottom line is that we ended up writing our own invoice report - we don't use any version of the BI010 report. Our report runs off of a view that picks up data from a custom table, then is joined to several standard tables on the report.
I have a formula that does grouping something like what is in parameter maintenance and use this formula for my section breaks. In an attempt to see which of these sections was displaying, I put in a text field with the name of the group headers / footers within each of the sections. I hoped this would show me which section was causing the break. I did find that I’m getting a page break between group header 3 and group header 4. I normally have both of these group headers suppressed as they don’t contain anything I need on the invoice (I get the same page break whether the group headers are suppressed or not). The corresponding group footers are also suppressed.
I did a test based on what you suggested: I did a sql select of the fields in my group expert, grouping and sorting by those fields. The result set suggests that there should be no break at the point where I’m getting the break (between GH3 and GH4). Every record has the same value in groups 3 and 4. The nearest page break is at group 2, Draft_Num.
I don't understand why I would get a page break between GH3 and GH4 when the invoice is not the first one being printed, but no page break when it is the first one.
Hi Ruben,
It sounds like you are saying if the multi page invoice is the first invoice, then it prints OK. When it’s the second invoice though, it prints the group header, then pages. That makes it sound like something on the record is changing and Crystal thinks it has to page at that point.
Those reports are pretty complex. There are a series of formula fields that pull 4 character strings from a global parameter that is sent to the report, and then a group of ‘group and sort’ fields that tell the system how to group the records. As an example, the same report can be group by account category, by comment, by project billwith, by source transaction date, etc. Probably based on the section type used in invoice format maintenance. Without additional information, it’s hard to tell what it should be grouping on. There are a dozen or so possibilities. Let’s say as an example though that it’s grouping on the project bill with and account category. It sounds like the first invoice prints, then the group header of the second invoice prints before the system realizes that the project billwith and account category changed, and now that it realizes it changed, it has to do a page break to start a new page. That sounds like something is messed up on the report, but it might be hard to find as complex as that report is.
Sorri I don't have any concrete ideas as to what the issue might be.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148