 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2005Report previews multiple times
I work with a database that allows users to enter multiple discrepancies into a table under one unique report number. The table and queary both show the report number once for each entered discrepancy. I have a report that shows the discrepancy information in a sub-report, but the entire report repeats itself for each entered discrepancy. How can I get each report to preview only once if it has multiple discrepancies? Thanks for any help  SignatureDan I expect you have too much detail in your main report. It seems that the main report should not contain the discrepancy information. SignatureDuane Hookom MS Access MVP -- >I work with a database that allows users to enter multiple discrepancies >into [quoted text clipped - 5 lines] > itself for each entered discrepancy. How can I get each report to preview > only once if it has multiple discrepancies? Thanks for any help The main report does have a lot of information, but the discrepancy information is on fairly small attached sub-report. The sub-reports are grouped by report number with the main report, and the report number field is the only one the reports have in common. Dan > I expect you have too much detail in your main report. It seems that the > main report should not contain the discrepancy information. [quoted text clipped - 8 lines] > > itself for each entered discrepancy. How can I get each report to preview > > only once if it has multiple discrepancies? Thanks for any help Does your main report record source contain the discrepancy records? SignatureDuane Hookom MS Access MVP -- > The main report does have a lot of information, but the discrepancy > information is on fairly small attached sub-report. The sub-reports are [quoted text clipped - 17 lines] >> > preview >> > only once if it has multiple discrepancies? Thanks for any help Yes, it has two quearies that have the discrepancy information, joined to the main table by report number SignatureDan > Does your main report record source contain the discrepancy records? > [quoted text clipped - 19 lines] > >> > preview > >> > only once if it has multiple discrepancies? Thanks for any help You first stated "but the discrepancy information is on fairly small attached sub-report" and then stated the discrepancy records are alos in the main report. My suggestion has been to remove the discrepancy table from the record source of the main report. SignatureDuane Hookom MS Access MVP -- > Yes, it has two quearies that have the discrepancy information, joined to > the [quoted text clipped - 29 lines] >> >> > preview >> >> > only once if it has multiple discrepancies? Thanks for any help I removed the discrepancy table and found the problem was with my main report queary the whole time. It is based on quearies itself, and causing the repeat reports. I'm trying to rebuild the main report queary from tables to prevent that. SignatureDan > You first stated "but the discrepancy information is on fairly small > attached sub-report" and then stated the discrepancy records are alos in the [quoted text clipped - 34 lines] > >> >> > preview > >> >> > only once if it has multiple discrepancies? Thanks for any help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.