Question Re: Modify SQL query in Crystal Reports 2013 in Technology Q&A

Modify SQL query in Crystal Reports 2013

Former Member — Sat, 12 Jul 2014 15:18:37 GMT

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

Re: Modify SQL query in Crystal Reports 2013

Former Member — Mon, 14 Jul 2014 12:53:03 GMT

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.

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

-Sastry

Re: Modify SQL query in Crystal Reports 2013

abhilash_kumar — Mon, 14 Jul 2014 13:30:32 GMT

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

Re: Modify SQL query in Crystal Reports 2013

Former Member — Fri, 01 Aug 2014 08:40:49 GMT

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