Hi,
My name is Dennis Schmidt. Thank you for using the Microsoft Windows
Installer Newsgroups.
I can give you the basics on how to accomplish this. You will have to play
with the layout of the report to get it displayed the way you would like.
It has several components:
1- Create a "Main" report that is based on the table or query with the data
you want in the report.
2- In the report set Sorting/Grouping on the "District" field. Be sure to
add a group header and footer.
3- Place the "District" field in the report header.
4- Place the remaining fields you want in the detail section.
5- Set the PageBreak property of the group footer to break "After Section"
6- Create a query just like the record source for the "Main" report.
7- As the criteria for the "Recion" column type:
Not Like Reports!NameOfMainReport!District
8- Create a new "Sub" report based on this query, arranging the report the
way you want it to display.
9- Place the "Sub" report in the group footer of the "Main" report.
When the report runs, it will print the district info first and below it
run the subreport with all data but what is displayed above. It will
continue to do this for each dirstrict in the Main report.
I hope this helps! If you have additional questions on this topic, please
reply to this posting.
Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
Regards,
Dennis Schmidt
Microsoft Support
