I am fairly new to CR, and am having a tough time getting a couple things in my report to work as I want.  I have Googled and searched this forum, but haven't found my answer, so.....here I am.

I have a report that displays work orders that were closed within a user-defined date range.

In each group header I have a total work order count which works fine.  The piece that I am trying (unsuccessfully) to make work is a conditional count in the group header.  I have a Running Total field in the header; the Type of summary is set to sum (I also tried count), and under Evaluate I have chosen Use a formula.  Here is my formula:

if {database field for date completed} <= {database field for date due} then
1
else
0

I want this to tally all of the work orders that were closed on or before their due date.  When the report is run now, the Running Total field displays nothing.

Any help/direction is appreciated.

AC




Edited by AvalancheChaser - 17 Jan 2008 at 11:18am

Thanks for the help!  That works great!

Two last questions that I'm now struggling with:

1) How might I go about totaling all of the values given in the group header by the second formula?

Ideally, I'd like this total to go in the report footer.

2) How do I tell CR not to repeat the group header on a second page if the details for that group run onto the next page?


Thanks so much for your help, I really appreciate it!

AC

You d' man.

Thanks!




AC