adding various activities

[radiated]

I have built a cross tab report which appears to be functioning well.
The problem I now have is that I need to add several of the various columns together but not all of them and I don't know how to do it.
The data forming these columns comes from {Schedule.Activity} and there are approximately 25 different activities that are seperately totalled and I need to be able to combine these activities in different ways to arrive at different totals as required by my boss. These {Schedule.Activity}'s are arranged in the report by the {schedule.activity}'s status. There is approximately 8 different status catorgories. These catorgories are C,X,FC,SC,N,X,etc... Now suppose I want to calculate or sum the catorgories {Status} of C,FC,SC of say the {Schedule.Activity} of OX11. I would prefer not to make this part of the cross tab report but a summary of the report in maybe the footer section which probably calls for me to construct a formula that calls on the data from the cross tab report to report it in the footer section.

Can you people please help me construct this formula and let me know if I'm thinking along the right lines?
Thanks
Jim

 

[synapsevampire]

You can use a Running Total, though you don't make references to the crosstab data, rather to the database.

I think what you want is a Running Total and place the criteria in Evaluate->USe a Formula.

You'll get much better responses if you include some sample data and expected output.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[radiated]

Let's see if I can outline what I am trying to do.
I work at a hospital and this report tracks the various activities that the patient(s) go through. The activities are consults (both out patient and inpatient), re-evaluations, treatments, follow ups, re-consults, simulations,etc...
What I am trying to do is write a report that will report out these activities and their respective status. There are several different possible status codes such as: C=Complete, D=Done, X=Canceled, SC=Start Complete, N=No Show, etc... I have constructed the Cross Tab report and it works fine. However, now I need to try to combine some of the data (activities) according to their respective status. I need to show both the total breakdown of all activities and the sum of related activities.
These related activities would be such things as: Consults, re-evaluation, and re-consults.
How can I do this?
I would like to show this data seperate from the Cross Tab report but in the same report. Like maybe a summary of the report in the footer section of the report.
All of data is number format. So it would be adding the total of these various {Schedule.Activity)'s together and then giving that total a generic name that would represent the various {Schedule.Activity)'s.

Let me try to write an example:

Schedule.Activity consult 50
Schedule.Activity Re-Eval 10
Schedule.Activity Re-Consult 20

The cross tab report reports out these seperate stats but now I have to combine into a general group which I will call "All Consults". Also, I will want to show this statistic in a seperate portion of the report, a summary of the report.
It will add the three totals above to arrive at:

All Consults = 80

This summary would contain several different general groups that would incorperate different seperate specific.

Does this information help?
Thanks for your help, I appreciate it and I will check back in the am for any help that you all could possible give.

Thanks
Jim

 

[radiated]

Hi:
I just wanted to bring this back to the top and see if anyone had a response.
The {Schedule.Activity}'s are listed on the left of the cross tab and the different status's are on top with the totals for each {Schedule.Activity} at the bottom of each column.
What I want to do is create a formula which I can use to total the related {Schedule.Activity}'s and then insert that formula into a pre-designed template in another section of the report.
Does that make sense?
I was thinking of putting this pre-designed template in the footer section of the report and then when I got the report all working right I would suppress the section that the cross tab was in and just print out the section with the template was in with the data that was really needed.

Sort of like this:

consults formula giving total of related activities

treatments formula giving total of related activities

ETC....

Please help
Thanks
Jim