Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Location of SQL Query 1

Status
Not open for further replies.

Tolli1

MIS
Joined
Nov 18, 2002
Messages
4
Location
GB
I have a number of reports which attach to SQL queries, however in v8.5 I can't establish the query location. I'm sure in v7 I used to click on set database location and the file path for the query would be provided. Is there an equivalent in v8.5.
Thanks
Tolli1
 
Yeah, they messed that up. It should show on the data explorer.

To find it now you can pretend you are going to add a formula and open the formula editor. Then look at the table name in the list of fields at the bottom. It will give you the name of the QRY and the full path.

You will also see this in the field list of the select expert, and on the fields tab of the report expert. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top