9 Replies Latest reply on Sep 2, 2009 11:43 AM by dinora

Totally the number of schools in a report

Title

Totally the number of schools in a report

Post

I am writing a report that gives me the number of students with special needs in a school district.  I can find the total of students in each school district but I want to find the total number of schools.  When I count the number of schools I get the same total as the number of students.

Even though there are 5 students from one school can I get the value of the school changed to 1 instead of 5.

So if I have 300 students in total I may have a total of 32 schools instead of 300.

• 1. Re: Totally the number of schools in a report

The tables or databases you use?

The relationships?

All info is good.

• 2. Re: Totally the number of schools in a report
You will need to use a subsummary report grouped by school. When you put your count summary field in the subsummary part, it will display how many you have for each school.
• 3. Re: Totally the number of schools in a report
See if this helps.
• 4. Re: Totally the number of schools in a report

Hi Mr Vodka

I have the same problem but I cannot get it to work - Can you explain my problem is with menu selections I have guests that are choosing Beef, chicken, Fish this is a radio button pulling from value list then I have a dessert option "dessert" "Fruit Cup"

I have a report which shows me how many guests are having chicken with subsummary showing the desserts and Fruit Cups

Then the next group is Fish with dessert and Fruit Cup

But What I need is a count for each of these subgroups

And I dont seem to understand how you do this??

• 5. Re: Totally the number of schools in a report

Dinora wrote:

Hi Mr Vodka

I have the same problem but I cannot get it to work - Can you explain my problem is with menu selections I have guests that are choosing Beef, chicken, Fish this is a radio button pulling from value list then I have a dessert option "dessert" "Fruit Cup"

I have a report which shows me how many guests are having chicken with subsummary showing the desserts and Fruit Cups

Then the next group is Fish with dessert and Fruit Cup

But What I need is a count for each of these subgroups

And I dont seem to understand how you do this??

Sounds similar to a thread you already started:

Might be better to ask your questions in that thread, rather than hijack this one.

• 6. Re: Totally the number of schools in a report
Yes you are correct - But this is exactly the same problem as my thread - Can you help?
• 7. Re: Totally the number of schools in a report

Besides I would not call this highjacking - I am following up on this for me and for the author of the question

Thanks in advance for all your help

• 8. Re: Totally the number of schools in a report

Dinora wrote:
this is exactly the same problem as my thread

No, it's not.

• 9. Re: Totally the number of schools in a report

Going back to the original question for this threat

It was advised by mr vodka as follow

You will need to use a subsummary report grouped by school. When you put your count summary field in the subsummary part, it will display how many you have for each school.

I do not know how to do this can anyone further explain -