By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,304 Members | 1,739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,304 IT Pros & Developers. It's quick & easy.

How do i view the SQL statements behind an existing report

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.