Counting Formula Help

[RichCha]

Counting Formula Help

Crystal Reports - Version 10.

Hello everyone... I need to create a Counting Formula that will display my results in the report footer. I have two fields {FORM.ELEMENT_NAME} and {FORM.ELEMENT_VALUE}. My 'Select Expert' is set {FORM.ELEMENT_NAME} is equal to 'Region'.

FORM.ELEMENT_NAME FORM.ELEMENT_VALUE
Region Dallas
Region Dallas
Region Houston
Region Houston
Region Houston
Region Houston
Region Austin
Region Austin

I can group the regions, and using running totals, and receive this... but that’s not the results I’m looking for.

FORM.ELEMENT_NAME FORM.ELEMENT_VALUE
Region Dallas
Region Dallas
2
Region Houston
Region Houston
Region Houston
Region Houston
4
Region Austin
Region Austin
2

I want to display only the totals of each Region in the report footer...

Dallas: 2 Houston: 4 Austin: 2

 

[synapsevampire]

Since you explicitly state that you want them in the report footer, a group won't help.

And it appears that you want them in natural order, not alphabetical.

If this is not the case, spend more time on describing what you want, what you don't want isn't very useful.

For known values using your running totals, alter the running totals to say Evalaute-Use a formaul and each would have their respective {table.city} = "Dallas", etc., and change the Reset to Never and move them to the report footer.

If other formats are acceptable, consider dropping in a cross-tab, place the city as the column and a count in the summary field. This would provide the city on top and value below.

-k