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

Creating a report from a subform

P: 11
I have created a report from a subform. However, there is one nuance I have not been able to formulate. To give a little background. I have a table (Managers) and table (Staff). The main form information is related to the managers table. While the sub form is related to the staff reporting to that manager. It all works fine, except that I would like to create individual reports for each manager, rather than one continuous report that includes all the managers in the organization. Can anyone offer any suggestions on how to make this happen? Thanks.
Oct 26 '12 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 100+
P: 2,321
One approach could be to create first a report of managers, and have the staff as a subreport.

Finally open the manager report while applying a filter to select only one manager.
Oct 26 '12 #2

Expert Mod 10K+
P: 12,365
Group by manager and use a page break.
Oct 26 '12 #3

P: 11
Thanks to both The SmileyCoder and Rabbit. I'll try your suggestions and report back.
Nov 4 '12 #4

P: 11
Would someone be so kind as to provide an example of how to filter from the example I cited with the manager report and staff report , so that only, one, not all the managers appear on the report.

What would be great is if I could put a combo or listbox on the form and have the person select the manager and have only his / her report and subreport appear and ready to print. Or even a pop-up criteria box would suffice. I tried to filter the report by using this code:=([Manager Last Name]) in the "Filter" property in the data tab. However, I just keep getting a syntex error. I also tried just including one name in the query grid criteria. This did indeed limited the query to pull only one record. However, the report continues to list all the records. Any guidance on this matter would be greatly appreciated.
Nov 6 '12 #5

Expert Mod 15k+
P: 31,487
Asking for specific code is not really allowed, but hopefully you'll find enough concept information in Example Filtering on a Form to help you on your way. We can comment on your existing code for you, but simply doing it for you isn't what we do (generally). Hopefully though, the examples and explanation in the linked article will be exactly what you need.
Nov 6 '12 #6

P: 11
NeoPa Thanks for the info. Will let you know how it turns out.
Nov 11 '12 #7

Post your reply

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