Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Report printing Detail Section twice

Posted on 2014-10-27
9
Medium Priority
?
233 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
  • 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
Independent Software Vendors: 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever run into that annoying problem where the computer won't boot?  Wouldn't it be great if you had a tool that would make that disk boot again?  I have found one tool that works more often than not ...
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
Viewers will learn how to use the Hootsuite Dashboard.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

886 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