Report printing extra pages (1 Viewer)

RickHunter84

Registered User.
Local time
Today, 12:05
Joined
Dec 28, 2019
Messages
85
Dear forum friends,

I need your help with the following. I'm working in Offer report that prints on PDF, this works without a problem. The problem is that if the offer has 3 items in it, the offer prints with 3 pages (see attached). I have other reports in the program I'm building that print without this issue, so I'm not sure what is causing this. Any ideas what could be causing the report to print this additional pages? I looked at the other reports to compare the properties but they seem the same.

Please let me know if you need additional details. I'm working on Access 2016.

Rick
 

Attachments

  • QuoteRef_10112.pdf
    163.4 KB · Views: 323

Gasman

Enthusiastic Amateur
Local time
Today, 16:05
Joined
Sep 21, 2011
Messages
14,044
Have you checked the source data?
 

RickHunter84

Registered User.
Local time
Today, 12:05
Joined
Dec 28, 2019
Messages
85
Have you checked the source data?
Hello Gasman,

Yes, the underlying query doesn't have duplicates, if thats what you meant?

Rick
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:05
Joined
Sep 21, 2011
Messages
14,044
Best upload the DB with sufficient data to replicate.?
I was thinking new page on item, but you have the same data on all three pages that I can see?

I only have 2007, but someone else will be able to open it.
 

RickHunter84

Registered User.
Local time
Today, 12:05
Joined
Dec 28, 2019
Messages
85
Best upload the DB with sufficient data to replicate.?
I was thinking new page on item, but you have the same data on all three pages that I can see?

I only have 2007, but someone else will be able to open it.
that's going to be quiet difficult to be honest. I have a special online validation that requires knowing the user IP address to enter the program, wanna do a teams call? I don't mind showing it to you, if you want.

Rick
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:05
Joined
Feb 19, 2002
Messages
42,970
Two problems.
1. your main report query includes a join to the sub report table. It has three rows, hence, the main report is repeated three times. If it had 4 rows, the main report would repeat 4 times.
2. You might want to use a page header rather than a report header so that each page has a header.
 

RickHunter84

Registered User.
Local time
Today, 12:05
Joined
Dec 28, 2019
Messages
85
Two problems.
1. your main report query includes a join to the sub report table. It has three rows, hence, the main report is repeated three times. If it had 4 rows, the main report would repeat 4 times.
2. You might want to use a page header rather than a report header so that each page has a header.
Hey Pat,

Thank you! You were right, I had an unnecessary join, extra pages are gone. I will follow your suggestion as well on no. 2.

have a nice day!

Rick
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:05
Joined
Feb 19, 2002
Messages
42,970
And my fingers never left my hand:)

Gasman had the right idea but he didn't push you in the right direction.
 

Users who are viewing this thread

Top Bottom