Picking Records from Various Groups and Totaling at End of Report

[spacemanspiffy04]

Hi,

I am a new CR XI user and have created the following report. The main group is by User ID, and within each user ID there are a number of US States. So, the report will look like this:

User ID States Amount
Bob MO 10
CA 20
TN 30
Total 60

Mary VT 5
OH 6
CA 7
Total 18

I need to have a seperate total section at the end of the report that sums up the Amounts based on each state.

Total MO 10
CA 27 (20 + 7)
OH 6
etc.....

The states within each User's group will change on a daily basis with new states being added and others being removed.

All information will come from the same database table.

Any help will be greatly appreciated!!!!

Thanks!

 

[Durango122]

hi
create a running total
do a sum on the amount for each record
reset on change of group


Durango122
Remember to used all fingers when waving to policemen

 

[spacemanspiffy04]

Hi,

Thanks for your suggestion! I might be doing something wrong here, but I followed the wizard and incorporated your suggestion, but it seems to only total up the records the records within each group. I need for it to total individual records within each group and create a total at the end. So, when OH appears across many groups, I need to it to total the amounts for each time OH appears and then give a summary total at the end of the report. I also need it to display OH beside the summary total.

The help menu suggest creating a formula, and that looks pretty straight-forward, but their idea only works if the values within each group are fixed. In my case OH might appear sometimes, and not appear at other times. Plus with 50 states, there could be endless combinations.

Thanks and once again, appreciate your help!

 

[lbass]

Insert a crosstab in the report footer where you use state as the row field and amount as the summary.

-LB

 

[spacemanspiffy04]

Thanks, LB!