Jump to content

Multiple records in one record


DZ
 Share

This topic is 5624 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by Guest
Link to comment
Share on other sites

  • 1 month later...

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

  • Newbies

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

This topic is 5624 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.