Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-28-2015, 11:06 PM   #1
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Unhappy Report repeats 35 times

I have designed a simple database to manage the publication of a weekly list of events. One report I have designed has two (2) sub-reports and prints in 2 columns on one A3 page - This week's events and featured future events. I have used a parameter form to set the date ranges for both sub-reports. When I run the report, it shows up 35 times.
I have another very similar report using exactly the same queries and parameter form but printing on A4 paper. It is made up of a base report and a sub-report and it prints once and usually stretches to 2 pages. I could not get the A3 report to print on one page when I tried the base report and one sub-report so went to 2 sub-reports to get it to work. It works fine but shows up 35 pages. I am just printing page 1 and everything is good but it is very annoying. Any ideas on where I should start looking for the problem.

DennisDown is offline   Reply With Quote
Old 09-28-2015, 11:14 PM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,457
Thanks: 68
Thanked 2,713 Times in 2,598 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Report repeats 35 times

have you tried copying the report and renaming it like yourReportA3 and set its page size to A3.
arnelgp is offline   Reply With Quote
Old 09-29-2015, 12:31 AM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report repeats 35 times

Quote:
Originally Posted by DennisDown View Post
...Any ideas on where I should start looking for the problem.
Look at the recordsource for the main report, does it have 35 records?

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-29-2015, 08:39 PM   #4
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Re: Report repeats 35 times

Thanks Arnelgp. I used the original report when I created the second one.
DennisDown is offline   Reply With Quote
Old 09-29-2015, 08:42 PM   #5
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Re: Report repeats 35 times

Thanks JHB.
You have hit the nail on the head. I get the same number of pages as there are records in the first query result.
Can you offer a solution? Is there a way of not getting the same number of pages as records in the query?
DennisDown is offline   Reply With Quote
Old 09-29-2015, 09:30 PM   #6
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report repeats 35 times

Quote:
Originally Posted by DennisDown View Post
...
Can you offer a solution? Is there a way of not getting the same number of pages as records in the query?
I think your query is wrong build, look at the recordsource you've for the other report which runs okay!
Else post a stripped version of database with some sample data (zip it) + the name of the report in which you've the problem.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-30-2015, 05:12 PM   #7
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Re: Report repeats 35 times

Thanks JHB
The two queries are exactly the same for the two reports and use the same parameters from the same parameter form. The main difference is the use of 2 subreports in the body of the report so that the information is printed on one A3 page (for print display) in 2 columns rather than on 2 A4 pages in one column (for emailing) with the subreport being in the report footer. The report footer option would not work for the A3 page.
I have uploaded a stripped database.
The report concerning me is: rptNewWeeklyProgramToPrint.
The report that works is: rptWeeklyProgramToEmail
This is a second year's iteration of the original database where we are trying to add a "Featured Events" section for events that are 'checked' when entering the event.
Thanks for your help.
Dennis
Attached Files
File Type: zip EducationEvents2016Stripped.zip (524.3 KB, 33 views)

DennisDown is offline   Reply With Quote
Old 09-30-2015, 08:53 PM   #8
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Report repeats 35 times

There is no data in the database, because the tables are linked to a backend database.
Normally main- and sub-report are linked together using the "Link Master Fields" and the "Link Child Fields", which do don't have.
I can't test it because of missing data, but have you tried to run the report without any recordsource, (unbound report)? Then the data should only show one time?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-30-2015, 09:10 PM   #9
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Re: Report repeats 35 times

Sorry about that. I forgot that it was split. I'll work on merging it and reposting. I'll have a look for the Master Child relationships in the meantime.
Thanks for your advice
DennisDown is offline   Reply With Quote
Old 09-30-2015, 09:58 PM   #10
DennisDown
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Re: Report repeats 35 times

HI JHB
I have zipped the back end. Hopefully you can make the front find the back.
Regards
Dennis
Attached Files
File Type: zip EducationEvents2015_4_be.zip (220.4 KB, 36 views)
DennisDown is offline   Reply With Quote
Old 09-30-2015, 11:38 PM   #11
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,457
Thanks: 68
Thanked 2,713 Times in 2,598 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Report repeats 35 times

please try, relink your table again.
Attached Files
File Type: zip EducationEvents2016Stripped.zip (521.5 KB, 38 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Tags
report duplication , reports , sub reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report detail repeats records mbryant Reports 10 04-23-2015 12:47 PM
Report Repeats Detail Information holmes213 Reports 1 05-06-2011 04:31 AM
Advanced query + report that sorts according to repeats tareksul Reports 7 12-20-2010 02:31 PM
Sum without repeats nikhatter Queries 4 06-06-2008 12:23 PM
Data in sub-report copied several times in main Report fred05 Reports 3 07-19-2005 12:06 AM




All times are GMT -8. The time now is 09:30 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World