I my question its simple for sure but this is my first report ;)

I already have a report that display employee results
by NrEmployee and between Dates

TableInfo
-Id
-Date
-NrEmployee
-...
-...

Now i whant to show all days between dates even they have no information to the selected NrEmployee

To have the dates i create a table with all dates from 2000 to 2020
and make the relation in crystal TableInfo.Date = AllDatesTable.Date

AllDatesTable
-Date

Now what is the best way to display all dates even when TableInfo.NrEmployee does not exists

I try with outer join etc option in crystal but with no sucess

Thanks.

I have comeback to this issue ...

Still need some help please,
 the right join when the parameter nrEmployee  IsNull not working

Thanks


Edited by vidaul - 10 May 2012 at 12:43am