How to implement an outer join within a Crystal Report

[Sielah]

I'm trying to put together a very simple report on help desk incident data. The report should display the number of non-impacted days on a month by month basis, grouped by either support team or by application.

The problem I'm experiencing is that the report only shows data for teams or applications that have some incidents attached to them. I know that I effectively need an outer join to force the report to display data even for teams and applications with no incident data.

Unfortunately, we are using MS Access as the database. When I try to set an outer join in the Database Expert, I receive an error message telling me this type of join is not supported.

So, is there any way I can force an outer join within the report itself, and to include teams or applications that don't have associated incidents?

 

[Madawc]

I don't know MS Access or why it's stopping you using a left-outer. But if no one has a better solution, you could have just the team data in the main report and do a detail-line subreport for the incidents. This will be slow but would get the job done.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[dgillz]

If you use an ODBC data source to attach to the Access data rather than attaching directly to the ,mdb file, left outer joins will be available.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?