Brandon Garnett
asked on
Access Report printing Detail Section twice
I have a report in Access that is using a subreport. The subreport may have up to 15 items in it. For every item in the subreport the report is printing. So I have 15 items printing on my report with 15 items in each subreport. My query is selecting Distinct records. Is there a way to not print the Detail section of the first report more than once and still have the subreport print the correct amount of times?
As an example:
(Report) Level: Chapter Title: Chapter 1
(SubReport) Task: Spellcheck
Task: Get Proof Read ' the subreport only prints one task at a time, so this would be the subreport printing twice
(Report) Level: Chapter Title: Chapter 1
(SubReport) Task: Spellcheck
Task: Get Proof Read
I only want it to print the one time for the level and title, and still get every task to show up below.
As an example:
(Report) Level: Chapter Title: Chapter 1
(SubReport) Task: Spellcheck
Task: Get Proof Read ' the subreport only prints one task at a time, so this would be the subreport printing twice
(Report) Level: Chapter Title: Chapter 1
(SubReport) Task: Spellcheck
Task: Get Proof Read
I only want it to print the one time for the level and title, and still get every task to show up below.
Can you attached a sanitized copy of the database?
ASKER
I cannot but if you would like I can attach the code I am trying to run along with screenshots of the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is the select statement I am using for both the form and subform.
SELECT DISTINCT BookDivisions.DivisionID, BookDivisions.Level, BookDivisions.BookNo, BookDivisions.ChapterNo, BookDivisions.SectionNo, BookDivisions.SubsectionNo, BookDivisions.SubSubsectionNo, BookDivisions.ParentID, BookDivisions.Title, BookDivisions.UpdateScope, BookDivisions.MostRecentPublishedResearch1 AS ['Primary Recent Research'], BookDivisions.RecentChapter1 AS ['Primary Chapter'], BookDivisions.MostRecentPublishedResearch1 AS ['secondary Recent Research'], BookDivisions.RecentChapter1 AS ['Secondary Chapter'], Div2Tasks.PrimaryEmployee, Div2Tasks.SecondaryEmployee, Div2Tasks.CompletionPercentage, Div2Tasks.ExpectedStartDate AS ['Expected Start'], Div2Tasks.ActualStartDate AS ['Actual Start'], Div2Tasks.ExpectedCompletionDate AS ['Expected End'], Div2Tasks.ActualCompletiondate AS ['Actual End'], Tasks.Task
FROM ((Div2Tasks LEFT JOIN BookDivisions ON Div2Tasks.DivisionID = BookDivisions.DivisionID) LEFT JOIN luBookLevel ON BookDivisions.Level = luBookLevel.BookLevel) LEFT JOIN Tasks ON Div2Tasks.TaskID = Tasks.TaskID
WHERE (((IIf([forms]![frmSelectReports]![cboPrimaryEmployee]>"",[Div2Tasks].[PrimaryEmployee]=[forms]![frmSelectReports]![cboPrimaryEmployee],""))<>False) AND ((IIf([forms]![frmSelectReports]![cboSecondEmployee]>"",[Div2Tasks].[PrimaryEmployee]=[forms]![frmSelectReports]![cboSecondEmployee],""))<>False));
I am not sure how to help you without looking at your report design and data. If you could provide a sanitized version, I would likely be able to help you in quick order, but other than that, good luck.
ASKER
I've requested that this question be deleted for the following reason:
I solved my issue by redoing my SQL statement
I solved my issue by redoing my SQL statement
If "redoing my SQL statement" is the appropriate answer then rather than deleting the question and no credit being applied, I feel I should get credit based upon my answer in comment #40407078.
Just because I could not see the SQL, did not mean that I did not identify that it was not the leading cause of the issue and thus ultimately brought about the resolution to the question.
Just because I could not see the SQL, did not mean that I did not identify that it was not the leading cause of the issue and thus ultimately brought about the resolution to the question.
ASKER
It was an issue with the query
Thank you. I appreciate it!!