-
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? :confused::eek:
-
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.
-
Gary's right, you'll need to create a group for the states.
Insert menu > group
-
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.
-
I got it, I just right clicked on the Program Amount field and said, Insert Subtotal. Thanks for the help. :D
