View Full Version : Report Group Header Problem


b19620719
12-28-2007, 10:54 AM
I initially designed my report with a query as the Record Source. Later I realized I could use the same report with different queries (different subsets of the same data) so I removed the Record Source from the Properties window and added some VB code to set it.

The "divider" at the top of the group section seems to have "remembered" the old query. It shows "qDomainValuesAllLOBAUTO.DomainID Header". When I try to generate the report it Access seems to be looking for the qDomainValuesAllLOBAUTO fields, even though they are not referenced anywhere in the report.

A similar report that I modifed in the same way has only "DomainID Header" and works as I expect is should.

Any suggestions?

Moniker
12-29-2007, 05:28 PM
Delete the field in question and add it again, but unbound. The field is still bound to the old query.

b19620719
12-31-2007, 04:20 AM
I am not talking about a field. The problem is with the "bar" that divides the sections of the report.

The dividers and content on the report currently appear as follows:
Report Header
- some text and fields
Page Header
qDomainValuesAllLOBAuto.DomainID Header
- text and fields for the group header
Detail
- fields for the detail section
Page Footer
- fields for page footer
Report Footer

b19620719
01-02-2008, 07:39 AM
I figured out how to make the change. Right-clicking on the group header bar and selecting "Sorting and Grouping" allowed me to modify the fields it was using to control grouping.