Getting a report from a layout to show just the total count of one field

[littlered136]

Hi

 

I am struggling to work out how to get my database to generate a report that shows the total characters for that day and not broken up by scenes. So it will show this is the total characters from the character field for that day from all the scenes. 

 

When you go on to the database.

 

username admin

password pirates

it opens on the list layout. if you click on scenes then click on the report button for all units (the middle one) it will each scene for that day and the characters for that scene. What I am trying to do is get it to show all the unique character total for each unique one for that day.

 

I thin it is the all unit report I need to duplicate and adjust something on it rather then a new script?? so I can still do the scene per day breakdown with the original button.

 

Hope this makes sense. I thought it was to do with the sub summary in the all unit report layout needs to be changed to something else. But I cannot get it to work.. 

 

any help would be so much appricated

 

thanks

 

Sarah 

 

Edited May 24, 2019 by Ocean West
file removed by request

[Steve Martino]

HUH?  Not sure what you want at all.  But take a look at this screenshot and tell me what total would you like to see:

Are you looking for the number 5?  If so, it's just a count of the related records.

 

[littlered136]

Hi 

 

no sorry wasn't sure if I explained it very well.

if say you click on the report button then in t popup click on the middle report button.. you will see it shows each scene to shoot for that day. and under each scene lists the characters needed on the right and the to the left of the list shows the scene total. 

 

What I would like it to calculate is the total for each different character / featured extra military character etc.

 

So for example I would like it to show

 

15th May 

so work out every type of character in on that date (not broken up by scenes) 

so if another scene that day had grooms but where using three. it would tell me there are three groups total for that day. 

 

does this help explain it better? if not I can quickly mock up a photoshop to show how I would like the report different to the al unit report one which breaks it up by scenes per a day.

 

thanks for your help so far .

 

Sarah

[littlered136]

Hi attached are two images

the first is how the report currently shows.. total characters per a scene as a list.

the second image shows what I would like.. you can see in one scene the number of grooms is 2 and one is 3 needed .. so it lists the total grooms for the day is 3.

the unit total currently works out the total of each character as the highest number and adds them all together.

 

hope this image helps more