By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Two Subreports in one Report - Redundant Data

P: 4
I have a report that keeps track of sales by company for any given month within a year. I am using two subreports embedded within a report to produce 2006 (one subreport) and 2007 (the other subreport) sales by station for any month I choose. The report works but I have two issues:

1) The subreports are located in the detail section of the report. The report should be three pages long but the report keeps repeating the data for a total of 27 times. What am I missing that makes this data repeat?

2) The 2 subreports are based on two separate queries and pull data from 2006 and 2007 but for the same month. On the first two outputs of the report (out of the 27 repeats > see Question 1) my group headers which lists the years does not appear. It begins to appear on the third output of the report.

Help?

baool
Apr 5 '07 #1
Share this Question
Share on Google+
7 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have a report that keeps track of sales by company for any given month within a year. I am using two subreports embedded within a report to produce 2006 (one subreport) and 2007 (the other subreport) sales by station for any month I choose. The report works but I have two issues:

1) The subreports are located in the detail section of the report. The report should be three pages long but the report keeps repeating the data for a total of 27 times. What am I missing that makes this data repeat?

2) The 2 subreports are based on two separate queries and pull data from 2006 and 2007 but for the same month. On the first two outputs of the report (out of the 27 repeats > see Question 1) my group headers which lists the years does not appear. It begins to appear on the third output of the report.

Help?

baool
It's hard to tell what's going on. How are the subreports tied to the main report. What is the main report based on and are there any group headers on the main report. It sounds like the main report has 27 records which is why the subreports are repeating 27 times.

Mary
Apr 6 '07 #2

P: 4
It's hard to tell what's going on. How are the subreports tied to the main report. What is the main report based on and are there any group headers on the main report. It sounds like the main report has 27 records which is why the subreports are repeating 27 times.

Mary
The main report is based off 2 separate queries that I created that list sales for any given month for 2006 (one query) and 2007 (the second query). The only information that the main report pulls from the queries is years (one group header) and the month (another group header).

As mentioned before, under the detail section of the main report I added two sub reports that list the actual sales by record. After posting this message yesterday, I moved the subreports to the year group header (moved from the detail section) and the repeating data was eliminated. Now the report repeats itself only two times.

The first set of the report is identical to the second set but it does not contain the year and month group headers from the main report. These headers only appear in the second repeat of the report.

How can I eliminate the first set of the report that does not include the group headers from the main report?
Apr 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
You haven't said how the subreports are tied to the main report?

Also I would put the reports in the Group Footer rather than the group header. And put them in the Year rather than the month footer.
Apr 6 '07 #4

P: 4
You haven't said how the subreports are tied to the main report?

Also I would put the reports in the Group Footer rather than the group header. And put them in the Year rather than the month footer.
I'm not sure how the subreports are linked to the main report but what I did was create two queries and copied and dragged them into the design of the main report. If you are referring to the link Child and link Master functions I currently do not have anything inputted in those fields.

The issue now is that on the first copy/set of the report it does not include the month header or the year header. These headers only appear on the second copy/set of the report. How do I get rid of the first duplicate of the report?
Apr 6 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
I'm not sure how the subreports are linked to the main report but what I did was create two queries and copied and dragged them into the design of the main report. If you are referring to the link Child and link Master functions I currently do not have anything inputted in those fields.

The issue now is that on the first copy/set of the report it does not include the month header or the year header. These headers only appear on the second copy/set of the report. How do I get rid of the first duplicate of the report?
If the subreports are in the group footer of the Month then put the month in the master child join. If it's in the Year then put the year in.

Mary
Apr 6 '07 #6

P: 4
If the subreports are in the group footer of the Month then put the month in the master child join. If it's in the Year then put the year in.

Mary
You are a genius! The report does not repeat anymore but the first page is now blank (only the page header shows no detail). If you know how to troubleshoot this please let me know, If not then it is ok.

Thank you for all your help.
Apr 6 '07 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
You are a genius! The report does not repeat anymore but the first page is now blank (only the page header shows no detail). If you know how to troubleshoot this please let me know, If not then it is ok.

Thank you for all your help.
Check the properties on the groups. Either the Start New Page or Keep Together property are probably causing this.
Apr 7 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.