Solved

Access Report printing Detail Section twice

Posted on 2014-10-27
9
225 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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

This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

626 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