Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Report printing Detail Section twice

Posted on 2014-10-27
9
Medium Priority
?
232 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 2000 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

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.
One-stop solution for Exchange Administrators to address all MS Exchange Server issues, which is known by the name of Stellar Exchange Toolkit.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

722 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