[RESOLVED] Group Totals

[Mr_Floyd1976]

Hi,

I have a report that currently has four goups...

Department
Consultant
Location
ContactType (count of visits)


Results are displayed as:

PhysioTherapy
Mr Consultant
Room 1
New 10
Follow Up 23



I want to add the total visits to the department group footer.

How do I do this?

Cheers

Mark

[brucevde]

Right click on the field you want to summarize.
Select the Insert-> Summary menu item.
On the dialog that is shown, enter the appropriate information. Make sure you check the "Insert summary field for all groups" option. Click Ok.
Delete the summaries it inserts onto the report that you don't want.

[Mr_Floyd1976]

Thanks for the reply, but I still cannot get what I want.

Maybe I should try and explain a little better.

My report has the following.

Group1 Header
Group2 Header
Group3 Header
Group4 Header
Group1Footer
Report Footer


Groups 1 - 3 only contain one item, a site, a location, a consultant. Group 4 can contain many items as the consultants can have new, follow up, procedure etc.

So, Group4 Header looks something like:

New 6
FU 10
Proc 1

Then for the next consultant it may have

New 3

I want be able to have my report footer show:

New 9
FU 10
Proc 1


Hope this makes sense.

Many thanks

Mark

[brucevde]

If you want to display the total "count of visits" by Contact Type within the Report Footer then you should use a sub-report.

Another option, if you have a fixed number of contact types, would be to create a running total for each type. But only use this option if the number of contact types is small. Note that you would need to update the report if a new contact type were added to the system.

[Mr_Floyd1976]

If you want to display the total "count of visits" by Contact Type within the Report Footer then you should use a sub-report.

Would you mind explaining a little more.. I have used sub-reports, but am unsure how I can display the count of visits by contact type - as it is not a fixed field.

Another option, if you have a fixed number of contact types, would be to create a running total for each type. But only use this option if the number of contact types is small. Note that you would need to update the report if a new contact type were added to the system.

This is how the current report is written. I thought that it would improve things to have it more dynamic.. But it is too much work I may aswell leave it.


Many thanks once again

Mark

[Pasvorto]

You can also use a running total and not reset it at the group break

[brucevde]

Would you mind explaining a little more.. I have used sub-reports, but am unsure how I can display the count of visits by contact type - as it is not a fixed field.

The sub-report would be exactly the same as the main report except you would only have one Group, Contact Type. In the Sub Report Group Footer put the Contact Type and the Summary field that counts the visits.

[Mr_Floyd1976]

The sub-report would be exactly the same as the main report except you would only have one Group, Contact Type. In the Sub Report Group Footer put the Contact Type and the Summary field that counts the visits.

I have done this and it works fine for the grand total , at the end of the report.

I want to do the same thing for one of the other groups too.

For example, the current sub report shows the total number of visits by contact type for the whole report. I want to show the total visits by contact type for each department.. (group1)

Any ideas?