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]

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