CR Formula Question

[TheGoldenShogun]

I don't know if anybody is really familiar with Crystal Reports Formula Generation, but I'll give this a shot.

I have a report, it displays a list of different cities in the United States and the cities are organized and group by state. (IE Charlotte, followed by Raleigh are under North Carolina). Now then, I have a total for each city listed next to that city, seperate by year. Like so..

NORTH CAROLINA
Charlotte 10,000
Raleigh 20,000

TOTAL FOR NC - 2001 XXXXXXX

Charlotte 15,000
Raleigh 5,000

TOTAL FOR NC - 2002 XXXXXXX

My problem is I can't seem to work the formula section right to generate just the total for that specific state in that specific year. I have all 50 states listed and when I try to get the sum of that Program Amount Field, I get the total for the entire united states instead of just that state. Can anybody give me a hand?

[Gary.Lowe]

I did something similar a while ago and the way I did it was to create a group by State in your case and then a total for the state in that group.

Don't know if this of any use to you.

[alex_read]

Gary's right, you'll need to create a group for the states.

Insert menu > group

[TheGoldenShogun]

Oh no, I have the Group Sections for both the State and the Year. My report looks perfectly fine, I just can't get the subtotals for the particular State at a particular Year. You guys are saying get the total for the group, what I am doing is inserting a Formula Field and trying to use the Sum() function for that Program Amount field. That's just returning the Sum of all the Program Amount's and supplying them all to me.

[TheGoldenShogun]

I got it, I just right clicked on the Program Amount field and said, Insert Subtotal. Thanks for the help.