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

Repeating Subreports

P: 1
I'm trying to create a main report (A) that creates a printout of all notes supervisors made for a single employee. There are five main categories of notes: Productivity, Professionalism, Initiative, Reliability, and Employee Development. Each of these main categories is a subreport (B), and each main category has a few subcategories, which are also subreports (C).

I've managed to successfully embed all the (C) level subreports into the (B) level subreports successfully. They are linked by employee ID #s, so when I type in the parameter value "36", for example, in the Productivity subreport, I get back all notes for employee #36 in that main category, and the notes are divided by subcategory. I did have a problem initially at this level with the subreports repeating as many times as I had records for that particular employee; I was able to solve this by removing the Supervisor Notes table (which is the table where all this info is found) from my query for the (B) subreports.

Now the problem is when I embed the (B) level subreports into the (A) main report, I want to set parameters so that it will print out only the notes for a particular employee between specified dates. The Supervisor Notes table is the table that contains the Date field, so if I remove the table as I did for the lower level (B) subreports, then I no longer have a Date field in my query to set parameters.

Any ideas?
Mar 14 '12 #1
Share this Question
Share on Google+
1 Reply

P: 759
Can you post a good picture with the database relationships ?
Mar 15 '12 #2

Post your reply

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