Diplaying a count of 0 1

[rnc110]

I have a report that shows the name a an employee then a count of how many forms they have turned in. This works fine and even shows an employee if the count is 0. When I try filtering the data between a certain date the only date returned is if a form is turned in during the certain period
(basically a count >=1) How can I get it to display the names with no records during that period. (I already tried to change the links to outer joins)

thanks in advance
ryan

 

[Smitty020]

Hi Ryan, It's about time you get on here! Try praying! LOL! Just kiddin buddy! An outer join is all can think of! Isn't there a property where you can include all. Goto design, right click, ect. There's couple of filter things in there.

Have fun and drop me an email,
Smitty

 

[Smitty020]

hey try this to:

make a formula for the number of things turned in.
then do an if statement and call it (@count)

if date > "date" the (@turned_) else 0, then make another formula called total count and do a sum

Sum(@count)

then you can total them in the footer or whatever

that might work...I did something similar in a report I'm working on!

 

[IdoMillet]

The problem is that the Outer Join allows you to return employees with no forms. The date field in such cases is NULL, and hence fails the date check.

Change the date check to add something like
...OR IsNull({MyFormTable.MyDateField})

Alternatively, change the SQL expression to include
the date condition as part of the ON clause
as opposed to part of the WHERE clause.

Cheers,
- Ido