Modify SQL query in Crystal Reports 2013

[Former Member]

Bonjour,

Je voulais savoir s'il était possible de modifier la requête SQL dans Crystal Reports 2013, car les bases de données de notre application pour bibliothèque utilise un format de date particulier qu'il nous faut corriger directement dans la requête SQL.

Merci pour vos informations.

Cordialement

Claude Marcilly

Cannes - France

Hello,
I wanted to know if it was possible to modify the SQL query in Crystal Reports 2013. Databases of our application library indeed use a particular date format that we need to fix directly into the SQL query.
Thank you for your information.
Best regards
Claude Marcilly

Cannes - France

[abhilash_kumar · Accepted solution]

Hi Claude,

You can modify the SQL Query *only if you're report is based on a Command Object* - SQL Queries added via the 'Add Command' option.

To edit such queries, go to the Database Expert > Right-click the Query from the pane on the right > Select Edit.

-Abhilash

[Former Member]

Hello,

Sorry for my late reply but my workload did not allow me to free me earlier.

I am going to test your solutions but I have only Crystal Reports 11 (on Windows XP)

I downloaded Crystal Reports 2013 trial version on Windows 7 but the ODBC driver to reach my databases is not compatible with Windows 7.

A datawarehouse solution should be installed soon and would solve all these problems.

I shall contact again you at this moment if I meet certain difficulties.

Anyway thank you for your explanations.

Claude Marcilly

[Former Member]

Hi Claude,

If you are creating reports using tables then go in Database menu and click on show SQL query, this will show the SQL generated by crystal reports.  Now go in database expert and expend your connection and double click on Add Command and past the query which was generated by Crystal and try to modify the date format and click OK.

Now you need to redesign your reports based on Add command.

or

If your reports datasource is Add command you can directly go in add command and change it.

-Sastry