Parameter with Summary

[DVFS]

I have a report I am trying to show amount of scheduled events for a coming week based upon a parameter and summary formula. I have this formula I am doing a sum summary off of:

if {CAL.ACTVCODE} = "TRN" and {CAL.ONDATE} = {?TRNSC} then +1

I simply want it to count the number of events for the date range parameter {?TRNSC} I created but it doesn't seem to be displaying the correct total. It is probably something simple I am overlooking. Please let me know what I am doing wrong.

Thanks, Joe

 

[synapsevampire]

I'm still not positive what you want.

If you're trying to limit rows inm the report for the parameter date value, use Report->Edit Selection Formula->Record:

{CAL.ONDATE} = {?TRNSC}

Then if you want to count certain types of events, you can create formulas such as:

if {CAL.ACTVCODE} = "TRN" then
1
else
0

Drop the formula in the details, right click it and select insert summary->Sum

Now you can delete this from the details if need be.

You can also use Running Totals or a crosstab might even be the easiest.

-k