How do i view the SQL statements behind an existing report

[tommy]

I am working with the Invoice report in the Northwind sample database.

How can I see the SQL statement that provides the data to the report?

Thanks.

[fredg]

On Wed, 26 Jan 2005 03:07:43 GMT, to***@yahoo.com wrote:

I am working with the Invoice report in the Northwind sample database.

How can I see the SQL statement that provides the data to the report?

Thanks.

Open the report in Design View.
Show the report properties window.
Click on the Data tab.
The first property is RecordSource.
Click on that line, then click on the button with the 3 dots that
appears.
That opens the QBE query window. Click on the View tool button arrow.
Select SQL.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Bookreader]

On Wed, 26 Jan 2005 03:27:05 GMT, fredg <fg******@example.invalid>
wrote:

On Wed, 26 Jan 2005 03:07:43 GMT, to***@yahoo.com wrote:

I am working with the Invoice report in the Northwind sample database.

How can I see the SQL statement that provides the data to the report?

Thanks.

Open the report in Design View.
Show the report properties window.
Click on the Data tab.
The first property is RecordSource.
Click on that line, then click on the button with the 3 dots that
appears.
That opens the QBE query window. Click on the View tool button arrow.
Select SQL.

When I try to do this I only see ControlSource in the Data section.
Am I using the right tool.

When you say "Show the report properties window." do you mean click
the properties for the field I want to see? Or do you mean that I
should be able to get properties for the report itself. Because I
can't find anything like that.

Thanks.

[Bob Quintal]

Bookreader <bo***********@yahoo.com> wrote in
news:j2********************************@4ax.com:

On Wed, 26 Jan 2005 03:27:05 GMT, fredg
<fg******@example.invalid> wrote:

On Wed, 26 Jan 2005 03:07:43 GMT, to***@yahoo.com wrote:

I am working with the Invoice report in the Northwind sample
database.

How can I see the SQL statement that provides the data to
the report?

Thanks.
Open the report in Design View.
Show the report properties window.
Click on the Data tab.
The first property is RecordSource.
Click on that line, then click on the button with the 3 dots
that appears.
That opens the QBE query window. Click on the View tool button
arrow. Select SQL.

When I try to do this I only see ControlSource in the Data
section. Am I using the right tool.

After you opened the report in design view you clicked on
something (a control) you were not instructed to above before
opening the properties window.
When you say "Show the report properties window." do you mean
click the properties for the field I want to see? Or do you
mean that I should be able to get properties for the report
itself. Because I can't find anything like that.
He meantproperties for the report itself.
To get back to the report itself, after having clicked a
control, find a little square in the frame at the intersection
of the horizontal and vertical rulers. Click once, a little
black square appears, and the properties change to those of the
form/report.

Thanks.

Welcome.
--
Bob Quintal

PA is y I've altered my email address.