totalling information in report

[emanna]

i have a report that i am listing incidents by person and a total of those
incidents for each person

i.e.

joe
running 5
walking 2
skipping 3

sam
running 2
walking 3
etc.

i then want to place a total at the end of the report showing a total for
each incident

walking 5
running 7
skipping 3

i have a parameter in my query for date. therefore when i open the report,
it asks for the parameter but of course that information is not show on the
report.

i already have a field that lists the incident and then a field that counts
the incident.

the only thing that i can think of doing is placing a list box at the end of
the report based on the incident and count of incident off of the same query
as the report is based on.

the problem with that is that now it asks for the query twice.

anyone have any advice. i am sure that i am doing this all wrong, but i
don't know what else to do.

hope this all makes sense. tia.

 

[Vinayak N]

Hi Emanna,

Did you try using the property 'running sum' available for the text box
that you would place in the footer of the report.

Have you tried using the Report Wizard to create your particular report
wherein you would have a SUMMARY option where you can specify which
fields you want to group and which you want to sum/average..etc

Also what do you mean by "it asks for the query twice"...does it prompt
for you to enter the date in the prompt once again?

Let me know if any of the above were of help.

Regards,
Vinayak

 

[emanna]

darn it...that was a typo...i meant it asks for the parameter twice. i think
my problem is probably b/c i am using a list box for it to list the incidents
and their totals at the end of the report.

let me try out what you suggested and see if that helps.

thanks