DZ Posted June 10, 2006 Share Posted June 10, 2006 Hi we have 200 school,we do job for all schools every day,at the end of the month I have to do report showing school ID,schools name,total of jobs,total of copies. How do I do that? Please(por favor) Link to comment Share on other sites More sharing options...
Wim Decorte Posted June 10, 2006 Share Posted June 10, 2006 Not enough information, DZ. How is your database structured? What have you tried and how did it fail? Link to comment Share on other sites More sharing options...
DZ Posted June 10, 2006 Author Share Posted June 10, 2006 (edited) When I sort school ID and month it is show me all record for that school. My boss only want to see the total of jobs and the total of copies that we did in one month he doesnt wants to see all record. What I need is layout that when I sort show me just one field for school ID,one for school name one for total of copies and one total of jobs. Edited June 10, 2006 by Guest Link to comment Share on other sites More sharing options...
bdam Posted July 11, 2006 Share Posted July 11, 2006 DZ, I think what you need is a layout that has a sub-summary section but no body. You will have to have to do your search and sorting from another layout and then switch into the report layout. To do the totals you will simply need to define some summary fields (ie: count). If that doesn't make sense then post the DB with some sample data. Bryan Link to comment Share on other sites More sharing options...
Newbies boreal Posted July 11, 2006 Newbies Share Posted July 11, 2006 Hola, (Hi). As far as I can understand, you need a subsumary. But first of all, you need to create some summary fields in which report will show you total amount of copies, jobs, and so on. Once you have those fields created, you will need to put them in a sub-summary. If you need further help, please tell me. Hope it helps you. Saludos Cordiales. Link to comment Share on other sites More sharing options...
DZ Posted July 12, 2006 Author Share Posted July 12, 2006 Thank you so much for response. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6498 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now