Repeating data

[Rich]

I have a report based on one query named AR Query and 6 subreports. The
subreports are linked to the AR Query and are hidden. The first 3 subreports
are linked by the Project # field of the AR Query and by a date field on the
main part of the report. The second 3 subreports are linked only by the
Project # field. I'm only displaying the totals and grand totals in group
headers. The report basically works but the first record displays the same
data as the last.
It doesn't matter what I make the first record, it still displays the same
data as the last record.

Can anyone please help me with this?
Thanks

 

[Duane Hookom]

It would help if you provided some specific information on the record sources
and the Link Master/Child properties.

 

[Rich]

The queries are as follows: AR, AR Data, Orders, Invoices, AR Data1, Orders1
and Invoices1. AR Data is linked to the Project # field which is a text
field. Orders and Invoices are linked by the Project # field and a date field
in which I'm using a DatePart to show just the year. When the report opens,
you are prompted to input what year you want see. When the report runs, the
first record has the same data as the last record except for the project
number and name. For example:
Project #1 Widget Test 29,830 31,203 29,412 31,092 -1,262
Project #2 Wacky Project 0 298 18,859 0 0
Project #30 Last Project 29,830 31,203 29,412 31,092 -1,262

The data for the last is the correct data while the data for the first
project is not. The data for projects 2-29 are correct. I would look at the
individual subreports to very this.

 

[Duane Hookom]

I would try display the linking fields in the main report and subreports.
Make them different colors so you can easily see them.

 

[Rich]

Thanks for your replies, Duane. However, I was able to correct this myself.
It turns out, that the fields that I had displaying the data were in the
wrong place. I had them in a group header when they should've been in a group
footer. I moved them there and everything works fine.

Thanks again.