I am trying to fix a report that has an issue with a widowed group footer. I have tried using Crystal Knowledge Base, article id c2008983, example 2 to fix my problem, but I get an error "The summary / running total field could not be created."
Research on Deja led me to the assumption that I had a problem with my running total. The error message remained after the running total was removed from the report. None of my remaining formula have anything to do with data appearing in the details section.
The Crystal KB example uses only a simple report with a single detail section and group footer. Do to conditional formatting needs, the particular report that I'm working with contains the following
1 page header section
6 group header sections (all for Group #1)
2 detail sections
2 group footer sections (Group #1)
3 page footer sections
(report header/footer sections are not used)
The problem occurs when the details for the report fill a page exactly, leaving no room to print the group footer (which is a summary for an individual order, of which the total report can contain many orders). The group footer then gets pushed to the next page, but because only the group footer is being printed, the group header doesn't - presenting a page that is blank in the middle of the page,(The report recreates an order form).
Ideally, I would like to 'push' one or two line items from the detail section onto the last page (with the group footer), so that the report end-viewer doen't get confused with a seemingly blank form/page.
I cannot use a system to count the number of items in the details section, as the details section contains an optional 'comment' field for each item that could be any length. Additionally, I have several comments that could appear in the group header that once again are variable in length. I also cannot put the column header (for details) in the page header do to the ordering needed for the comments; it appears in the 6th section of the group 1 header and prints on all pages, while the remainder of the group 1 header only prints on page 1.
I know this is a complex problem, but any help or suggestions would be greatly appreciated.
Research on Deja led me to the assumption that I had a problem with my running total. The error message remained after the running total was removed from the report. None of my remaining formula have anything to do with data appearing in the details section.
The Crystal KB example uses only a simple report with a single detail section and group footer. Do to conditional formatting needs, the particular report that I'm working with contains the following
1 page header section
6 group header sections (all for Group #1)
2 detail sections
2 group footer sections (Group #1)
3 page footer sections
(report header/footer sections are not used)
The problem occurs when the details for the report fill a page exactly, leaving no room to print the group footer (which is a summary for an individual order, of which the total report can contain many orders). The group footer then gets pushed to the next page, but because only the group footer is being printed, the group header doesn't - presenting a page that is blank in the middle of the page,(The report recreates an order form).
Ideally, I would like to 'push' one or two line items from the detail section onto the last page (with the group footer), so that the report end-viewer doen't get confused with a seemingly blank form/page.
I cannot use a system to count the number of items in the details section, as the details section contains an optional 'comment' field for each item that could be any length. Additionally, I have several comments that could appear in the group header that once again are variable in length. I also cannot put the column header (for details) in the page header do to the ordering needed for the comments; it appears in the 6th section of the group 1 header and prints on all pages, while the remainder of the group 1 header only prints on page 1.
I know this is a complex problem, but any help or suggestions would be greatly appreciated.