>>If I would design this by myself, I would do few left joins (right now I'm trying to do it in one select by using subtables- I assume this is how Doug is doing it internally - BTW, it would be nice to see the Select statement which is generated to produce a report).
>
>You can: in Step 2 of the Quick Report Wizard, click Advanced, then click Next in the Customize Report dialog that appears to see and edit the SQL statement.
>
I don't see this in our version of SQuery. Also looks like the version we have has some problems. We may want to get a newer version, I'll try to install it right now, but I'm a bit afraid to somehow overwrite our existing version or have other problems...
>I suggest you attend our weekly Webinar as we cover this and many other things you've asked about.
>
Here again we just need to find some time, it would be definitely helpful, but I can do it in the evening or on Friday or Sunday...
If it's not broken, fix it until it is.
My Blog