I just don't seem to understand how the report designer knows how to skip page by record.
That's the problem, you cannot start a new page when the Dept changes, unless you have a hierarchical recordset.
You may have a Page Footer and/or Report Footer section but do you have a Group Footer section. They are not the same.
The DataReport does not have an "Unbound Mode" (despite what the controls indicate in design mode). You cannot, using code, set the values of controls in sections which will repeat (such as the Details and Page Footer sections).
Before I can offer more help you will need to post the DataReport form, the SQL Statement and the code that opens the report. But see the sample application.
Last edited by brucevde; Aug 15th, 2006 at 05:04 PM.
Reply With Quote