Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Totals and Variables with Crystal 9

Status
Not open for further replies.

kelley35

Technical User
May 13, 2013
1
US
Hi
I am trying to create a report with two groups - example: MainForm is the first group and the second group would be the forms for this group. I have a batchtotal for each group which I can get from summary. The second column requires a formula for date difference. Under Business Money Form 1 and 2 exceed KPI would be if datediff("d",recdate,enddate) >2 then 1 else 0 and I use this formula as a running total, then add it up but the next group of forms has a different KPI. My problem is the second grouping the Exceed KPI be if datediff("d",recdate,enddate)>3 then 1 else 0.

I am not sure how to accomplish -- for each group the forms within that group have a different KPI. The compliance is a percentage by form and MainForm.

Business Money Batch Total Exceed KPI Compliance
Form 1
Form 2

Business No Money
Form A
Form B

Any assistance is greatly appreciated - Thanks in advance
Kelley
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top