Correct formatting of main & subreports Access 2007

[Punice]

Having a lot of trouble designing a report with a subreport.
First Issue:
Initially, i want to know if I am formatting it correctly. Here is what I have:
Report Header - - Holds the main report title;
Page Header - - - The control header column names for the main report;
===========
Detail - - - - - - - The record data for it
Page Footer - - - Holds the subreport title;
Page Header - - - The control header column names for the subreport;
Detail (2nd) - - - The subreport data.

The report almost displays correctly, except that the main report displays multiple repetitive records. We can work on that problem, after I learn
whether or not I need to format the thing differently from what I am doing now.

I've read & tried the available help, but no joy.

 

[plog]

The report almost displays correctly, except that the main report displays multiple repetitive records

Most likely this is an issue with the data source the report is based on. I think you should put aside your Report for now and focus on your queries that feed it--if the data is wrong there it can't but help to be wrong in the report.

So, post sample data from the query/table your report is based on as well as its SQL if a query. Also, tell us why it is not correct for what you want.

 

[Punice]

When I used the query to display the records for a main report before I added the sub-report the records were displayed correctly.
Before I continue, though, my main concern is still whether or not I am formatting the subreport in the proper places on the report in the design mode.

 

[Mark_]

Can you post a sample DB with the report/subreport?

 

[Punice]

I solved my problem by using a very unprofessional method that i thought I'd try.
I copied the sub-report's page header, where the wizard placed it, to the sub's report header, just below the sub's title.
Then, used the 'Add Existing Fields' tool, to place the matching header data fields to the detail section of the sub-report. I deleted the fields that were the pseudo(?) header fields.
Doing that worked. I guess the old adage from my Fortran days, circa 1960, is still true,
which is 'if if works, it's a good program'. That's why programmers rely on the Q&A department to perform the magic.
This 84 year old EE who has never been trained to be a programmer, is a happy camper and will continue peeling this db development onion until I am finished with it.
Thank you all for helping me. This is my savior furm. It's the best.