HowTo do multiple Groups in Data Reports?

[happest]

How do you design multiple groups in data reports at design time. I am able to do this report in access2k but my problem is not all of my clients have access2k.
if more info is needed ask.

example

Report Title
Report Date

Month Year
Department
name Department Position hire date
name Department Position hire date
name Department Position hire date
name Department Position hire date
Department
name Department Position hire date
name Department Position hire date
{new page}
Month Year
Department
name Department Position hire date
Jason H
Database Admin & Program Developer

http://www.LuckyEagleCasino.com

 

[tedsmith]

For the second part of the report you can set up labels or unbound text boxes in the report and fill them up with data from a snapshot dynaset at run time.
Refer to either by name or position
Eg
DataReport2.Sections.Item(1).Controls("Organisation&quot.Caption = Licence
DataReport2.Sections.Item(1).Controls.Item(1).Caption = Title