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