>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.
Hi Frank,
I don't know which version. On the second step of the Quick Report Wizard I see Advanced button. When I press it I see a series of BeforeData script, AfterData script, etc., but I don't see the actual SQL.
Also I found few other problems (template changes are not reflected, changing font for some fields doesn't seem to work, etc.) so it looks like we somehow got the wrong version, though I have no idea how.
I downloaded yesterday the recent version but didn't have a chance to install it yet. Also I'm a bit afraid - is it safe to just install it? Will all our reports and configuration be preserved?
If it's not broken, fix it until it is.
My Blog