Formula/Summary field at the end of a report

[Razzle00]

Hi,

I need to create a report that has just 1 field in the summary band of the report (or report footer) that is a sum based on an expression like IIF(MyTable.MyField = True, 1, 0). There is no detail band,group band or and other fields. Just a summary field at the end of the report. How could I do this? Could it be done with sum(fld,condfld,cond)?

Thanks,

Razzle

 

[lbass]

Place your formula in the detail section and right click on it and insert a summary (sum, not count) at the grand total level. You can then remove the formula from the detail section.

Note that you are better off not using iif in CR as it sometimes fails when nulls are involved. Try using a simple if/then formula instead.

-LB

 

[Razzle00]

LB, I would rather not create a field in the detail band and then create a sum from that because once you delete the field from the detail band you cannot ever change the expression without recreating another field in the detail band. Can it be done with a formula field instead? How would you create a If/Then statement that is equivalent to
IIF(MyTable.MyField = True, 1, 0).

Thanks,

Razzle

 

[lbass]

Sure, make the first formula {@cond}:

if {MyTable.MyField} then 1

...and then reference it in a second formula:

sum({@cond})

...and place this in your report footer.

-LB

 

[Razzle00]

Thanks LB, that is what I'm looking for.