adding fields in crystal reports 9 1

[sabbathunter]

here is what i would like to do i want to add up the total of a certain field but broken down.

a clarification of this is i have catagory field, that will say either urgent, high, medium, or low.

i want to be able to add up seperately the number of jobs that were listed as urgent, high, medium or low.

is there a way to do this easily and make the totals appear at the end of the report?

if more clarification is needed let me know.

thanks


david

 

[vidru]

I'd use four running totals:

Right click on your category field > Insert > Running Total. Name the first one "Urgent"; change the 'Type of summary' to 'Count'; set 'Reset' to 'Never'; for 'Evaluate', click the 'Use a formula' option, then click the [x+2] button, and enter a formula similar to this:

{Table.Category} = "Urgent"

Repeat the above for High, Medium and Low, changing the running total names and formulas for each. Drag them into the report footer, and you should have your four totals.

-dave

 

[lbass]

You could also place a crosstab in the report footer where you use {table.category} as the row field and a distinctcount of {table.jobID} as the summary.

-LB