I made a custom report and which should be about 4 pages long but when viewed in print preview its 380 pages long! I keeps looping the report. Any help would be great. Thanks.
I made a custom report and which should be about 4 pages long but when viewed in print preview its 380 pages long! I keeps looping the report. Any help would be great. Thanks.
Readers will need some details in order to offer advice. You could post your database in zip format, or give some specifics on record source, purpose of the report, sorting/grouping...
I can't just post the db. It has some sensitive information in it. What would be the best way to provide the necessary information?
What do you mean by "Looping"?
Does it print the same page over and over?
Does it print the whole table when you want only a specific row from the table?
What code fires off the report? Do you specify criteria?
Do you get the same results when you double click on the report name from the navigation pane?
It prints the whole report over and over again. I have three different reports. The first is all records, the next two reports are specific data and they all do it. I can just hit the "next page" button an infinite number of times and once it gets to the end of the report the next page is the first.
Maybe you have a cartesian query result as the report recordsource. Is the report recordsource a named query? If so, what does the query result look like when you run it independently?
The three separate queries all run normal and produce the expected results. How do I verify the recordsource? The property sheet in the query design view is empty. (Forgive my ignorance, Im new to access)
Welcome to the forum.
Well I did suggest
...or give some specifics on record source, purpose of the report, sorting/grouping
There is some logic issue if you are getting multiple copies of the report. Can you show the code that processes the report?
How do your queries relate to your reports?
We need some concrete info on purpose, structure, something if we are to comment on facts.
I just ran the report independently and it works. I probably should have added that the reports are associated with navigation control. Again, Im new here so where is the code for the report located?
Record source is listed as: SELECT Pilots.[First Name], Pilots.[Last Name], Pilots.[Base Month], Event.[Event Name], Event.[Event Description], Event.[Valid Duration], Event.[Date Completed], Event.[Date Expires], Event.[Event Type], Pilots.[Certificate Number] FROM Pilots INNER JOIN Event ON Pilots.[Certificate Number] = Event.[Cert_Num];
So where /how exactly do you run the report that is failing or giving multiple copies?I just ran the report independently and it works.
That is what's different?
How many Pilots are involved? How many Events?
If the report is OK with this recordsource when run independently, then some code must be modifying that recordsource when run otherwise. When not working OK, are you running the report from a button click on a form? How do you differentiate one report run format from another?Record source is listed as: SELECT Pilots.[First Name], Pilots.[Last Name], Pilots.[Base Month], Event.[Event Name], Event.[Event Description], Event.[Valid Duration], Event.[Date Completed], Event.[Date Expires], Event.[Event Type], Pilots.[Certificate Number] FROM Pilots INNER JOIN Event ON Pilots.[Certificate Number] = Event.[Cert_Num];
Orange, we're both on the same track here. No need for both. I'll step aside.
Whats your email? Itll be easier if I could just send you a dropbox link.