Report with numerous calculations for Percentage by group

[JerryJay]

I use Crystal 8.5 and would like to create a report which returns several percentages from data stored in one table.

I want to calculate the percentage of events on the day of the week, time of day, location, if a physician was contacted, class of staff (regular vs part time contract etc), route ordered and route given to name a few of the fields I am calculating on.

I am able to create the percentage for DayOfWeek and Hour of day with not problem alone but hen I use the funtionality built into Crystal my groups bunch everything by whateveer my first group is.

Example:

Hour
8:00AM 25%
10:00AM 25%
8:00PM 50%

If I include Day of Week I get something like this:

Monday 25%
01-01-05
Wednesday 25%
01-03-05
Saturday 25%
01-06-05
01-13-05

How can I include several calculations to return percentages using the functions in Crystal. If not possible could someone help me with the formulas?

Thank you

 

[Madawc]

Have you tried using Running Totals? Even in Crystal 8.5, they are quite versitile.

Their limit is that you can only put them at the end of a group. But they can select using quite complex formulas.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10