Crosstab displaying a blank column on left outer join

[mcresong]

I have a crosstab report that displays Employees as rows and Certifications as the columns. The summarized field displays the date of the employee obtained that certification. I needed the report to display employees without any certifications, so I changed the linkage to Left Outer. Now the report includes all employees, but added a blank column (no heading or data) as the first column in my crosstab. I have tried suppressing blank columns & rows, but that didn't eliminate this first blank column. Any suggestions ?

Thanks !

 

[synapsevampire]

The blank column probably means that there are blank or null dates, which makes sense if they don't have certifications.

You might try creating a formula for use in the cross-tab which contains:

if isnull({table.date})
or
{table.date} < currentdate - 10000 then
cdate(2050,1,1)

Then you'd get a false date, if that's your concern.

I'd probably create 2 cross-tabs, one on top of the other, which are each filtered by whether people have or have not had certification. If they haven't. don't use a date field as it isn't applicable.

-k