Ignoring Parameter

[WelshyWizard]

Hi all,

I'll try and explain this as best I can. I'm using Crystal Reports 9.

I have a table which has a list of employees, dates they have booked time against and the hours they have booked (HrsBkd.db). I also have a table which lists all employees only (Emp.db).

All employees should work everyday.

In crystal I have a date parameter which filters the information between two given dates. The report should show all employees hours booked for the selected period. However, my problem is that if an employee has booked no time for the period then they don't show!

Is there a way, using the employee table that I can list the people with nothing booked as well?

If any one needs any clarification just let me know!

Cheers.

Today is the tomorrow you worried about yesterday - and all is well.....

 

[lbass]

You need to use a left outer join FROM the employee table to the hours booked table. The problem is that if you use any selection criteria on the second table, it will effectively undo the left join, and you will again lose the employees. What you could do is remove the parameter selection criteria, and instead use field suppression to eliminate hours on unwanted dates. Select the fields you want suppressed->format field->suppress->x+2 and use a formula like:

not({table.date} = {?daterange})

-LB