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?
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?
Comment