Detail band continues on the bottom portion of the page

rbuser

Hello,

I am in the process of creating a report that the data wraps on the bottom
portion of each page. The report has to fill each page in a form style.
Following is mainly how it looks. I am referring to the different fields as
F#.



|--------------------------------------------------------|

| |

|Normal Header |

|--------------------------------------------------------|

|Column Headings #1 |

|--------------------------------------------------------| ----

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 | P

|F1 | F2 | F3 | F4 | F5 | F6 | A

|F1 | F2 | F3 | F4 | F5 | F6 | R

|F1 | F2 | F3 | F4 | F5 | F6 | T

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 | 1

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 |

|F1 | F2 | F3 | F4 | F5 | F6 |

|--------------------------------------------------------| ----

|Column Headings #1 | | Date |

|-----------------------| | |

|F7 | F8 |-----------------------|--------|

|F7 | F8 | | Date | P

|F7 | F8 |-----------------------|--------| A

|F7 | F8 | Comments: | R

|F7 | F8 | | T

|F7 | F8 | |

|F7 | F8 | F9 (Memo Field) | 2

|F7 | F8 | |

|F7 | F8 | |

|F7 | F8 | |

|F7 | F8 | |

|F7 | F8 | |

|--------------------------------------------------------| ----

|Total F8 <-- Only prints at Page 1 of ## |

| Grand Total |

|--------------------------------------------------------|



I have tried different ways to make this work. If I have one page report
everything is fine. Two or more pages report gives me a F8 value of 1.
Since I only can display 12 records per page I have tried to create a group
break on a ppVariable value. Two ppVariables to be more precise. The
ppVariable1 is just a counter while ppVariable2 only increments every time a
multiple of 12 is reached. The group break is on the ppVariable2 change.
The first part (Fields F1-F6) works well but the second part of the form
doesn't show until all the data from the first part has finished printed. I
have used different methods, to mention some:



1. Base detail for Part 1 and GroupFooter0 with populated labels for Part2
(based on ppVariable2 break).



2. Different subreport alternatives:

a. Two subreports in the base Detail band,

b. One subreport in the base Detail band for Part 1, one subreport in
the GroupFooter0 band for Part2.

c. Two SubReports in the GroupFooter0 band. (This seems to work the
best so far)

d. A subreport within SubReport.



Any suggestions will be greatly appreciated.

Respectfully,

Emeria

digitalmetaphors

If you want to base a group break on a variable value, you have to code the
variable's OnGetText event. The reason is that the OnCalc fires after the
group asks the variable for its value, which causes the OnGetText to be
triggered. Keep in mind that the OnGetText fires every time the Text
property of the variable is referenced by you or in the report engine,
meaning that this fires more than once per record.

You question may be better suited to have a working sample demo to run that
shows the problem. That way we can run it and reconfigure it to see what the
problem is and what can be done to get it to behave the way you want it to.
Send all attachments to support@digital-metaphors.com preferably, using a
common sample database such as DBDemos, Employee.gdb or Northwinds Traders.


Cheers,

Jim Bennett
Digital Metaphors