Jade Report Writer outer joins

[ConvertFromOldNGs]

by Andrea Spurdle >> Tue, 6 May 2008 16:03:18 GMT

I have a problem with the Jade Report Writer, and I wonder if anyone knows of a solution to this.

I have a class of Campaign which has a reference allActivities. This is a collection which may contain 0, 1 or more activities.
I want to produce a report which will print
- one line for the campaign, if the campaign has no activities, or
- one line per activity, if the campaign has one or more activities

But I can't figure out any way to do this in one report. If I use a root collection of Campaigns and then insert any of the properties from allActivities in the detail of the report, then I get one line per activity, but if the campaign has no activities then nothing will print for the campaign.

I've also tried using joins but this did not help as you cannot do outer joins.

So far the only solution I have found is to do two separate reports, one for campaigns with no activities and another for the campaigns with activities.

Can anyone suggest a better solution?

Thanks
Andrea

[ConvertFromOldNGs]

by Torrie Moore >> Wed, 7 May 2008 3:59:26 GMT

Take a look at the Query Options in the Report menu. You should be able to set the Inclusive option for the Campaign class which will mean that Campaigns that don't have activities will be reported.

Torrie

[ConvertFromOldNGs]

by Dean Cooper >> Wed, 7 May 2008 4:54:31 GMT

Torrie's correct. This is possible to do, but not entirely obvious to set up In the JRW Designer, the Report/Query Options menu shows a dialog with Options and Types tabs. The Types tab for this report should have an entry for the Campaign class with a checkbox under the heading "Inclusive". Checking this (ie: setting the option to true) and OKing the dialog should make the report print for those Campaigns with no activities, effectively giving you an outer join.

Dean.

[ConvertFromOldNGs]

by Andrea Spurdle >> Wed, 7 May 2008 10:05:14 GMT

Aha - and the Types tab is only visible when you have a lower level collection in the report. I always wondered what was in there!

Thank you both very much
Andrea