I know this is going to be a simple solution for someone in the community,
but having a problem with a Report producing more pages of information than
needs to. I am building a report consolidating analysis information
pertaining to a single issue from two tables (tblCommon and tblAnalysis)
having the Problem ID in common (one to many relationship).
Initially, thought the multiple page issue would be resolved by using a
sub-report. It did and it did not... it got all of the analysis entries down
to a single list vice a single entry printed on a single sheet, but now it is
still printing multiple pages just with more entries on each.
The report and subreport are using the same record source: qry-rpt 1
SELECT tblCommon.[Date Created], tblCommon.IdentifiedBy,
tblCommon.IssueDesc, tblCommon.System, tblCommon.ID,
tblAnalysis.Analysis, tblAnalysis.EntryBy, tblCommon.Resolution,
tblCommon.AssignedTo, tblCommon.PerComplete
FROM tblCommon LEFT JOIN tblAnalysis ON tblCommon.ID = tblAnalysis.ProbNum
WHERE (((tblCommon.ID)=[Enter Problem Number:]));
The main reports uses: Problem ID; Date Created; Identified By; IssueDesc;
and Resolution. The user is asked to enter the problem ID when accessing the
report.
The sub-report uses the Problem ID to filter tblAnalysis for the associated
entries.
Where am I going wrong? How can I get the report to quit giving me 6 pages
when 1 page with 6 entries on it will do?
Thank you in advance for the assist.
MJ
|
Similar Threads
