Report Problem

[hascet]

Hello,

I have a form which has a sub form data sheet on it. On my report I have a sub report which contains the data sheet information. For some reason my report is generating a report for each record in my sub data sheet report. For example, let's say my report is 1 page. If I have one record in my sub data sheet the report works perfect and I have a 1 page PDF report generated. If I have two or more records though my output PDF has a corresponding number of pages to the number of records. 2 records=2 pages, 3 records=3 pages, etc. the report just duplicates for each record in my sub data sheet and each report has all of the records on it.

Any idea on why this happens? I have been stumped looking at this for days.

 

[JHB]

What is the record source for the main report?

 

[vbaInet]

Perhaps you have a Page Break control in your report or you've set the Force New Page property for one or more of the sections in your report.

 

[hascet]

What is the record source for the main report?

Ah, got it! My record source query for the main report had a relationship in it to my subreport record source table. Once I removed that relationship the report operates as I want it to!

 

[JHB]

Ah, got it! My record source query for the main report had a relationship in it to my subreport record source table.

I thought so, good you got it!