>>>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...
>
Hi Naomi,
what version are you using? This facility the view the SQL has been there for ages. In the Reports Explorer, choose the report you want, click on the Edit button, When the Edit Quick Report Wizard screen is displayed, click Next once, then you'll see the Advanced button just above the Help button. Click on Advanced, click Next once on the Customize Report screen and you'll see the SQL that has been generated for your report.