Modify SQL query in Crystal Reports 2013

[#1]

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

[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