Solved

Access Report printing Detail Section twice

Posted on 2014-10-27
9
223 Views
Last Modified: 2014-10-31
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.
0
Comment
Question by:rcimasi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 5

Expert Comment

by:TONY TAYLOR
ID: 40407037
Can you attached a sanitized copy of the database?
0
 

Author Comment

by:rcimasi
ID: 40407053
I cannot but if you would like I can attach the code I am trying to run along with screenshots of the issue.
0
 
LVL 5

Accepted Solution

by:
TONY TAYLOR earned 500 total points
ID: 40407078
You can attempt, but initially I think it has a join issue in a query.  That would duplicate data and it would possibly be embedded in the form (parent/child).
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:rcimasi
ID: 40407085
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));

Open in new window

This is the image of how the report prints
0
 
LVL 5

Expert Comment

by:TONY TAYLOR
ID: 40407128
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.
0
 

Author Comment

by:rcimasi
ID: 40416253
I've requested that this question be deleted for the following reason:

I solved my issue by redoing my SQL statement
0
 
LVL 5

Expert Comment

by:TONY TAYLOR
ID: 40416246
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.
0
 

Author Closing Comment

by:rcimasi
ID: 40416254
It was an issue with the query
0
 
LVL 5

Expert Comment

by:TONY TAYLOR
ID: 40416258
Thank you.  I appreciate it!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to make a short video of something I cannot simply screenshot? 11 100
deprecated mysql extensions 1 55
Software to convert png to .ico 17 76
watsup photo saving 6 24
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question