CODEWITHSUNDEEP
sqlcrystal-reports
Eric Wong
Eric Wong

Reputation: 81

View the sql queries used in to generate the report in Crystal Reports 2011

I got this .rpt file that is not done by me. I need to view the sql queries used to generate the report in Crystal reports.

I tried clicking, Database -> Show SQL queries. It just prompted me to enter some variables and when I click OK. It prompted me to enter userid and password.

Do I need to be connected to the database in order to do so? I only need to extract the queries, I do not actually need to run it.

Thanks in advance.

Upvotes: 2

Views: 10220

Answers (1)

Vadim Levkovsky
Vadim Levkovsky

Reputation: 336

You should be attached to database. Don't know why, but I don't know any workaround.

Solution suggested by Raihan (use File->Export) still need to set attachment to db.

Upvotes: 2

Related Questions