Joined: 29 Mar 2007
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: Using Freehand SQL Posted: 29 Mar 2007 at 4:10am
Hi,
We are currently upgrading our investment system at my work and the underlying reports in our system are written in 'Infomaker'.
The upgrade to our investment system uses Crystal Reports V.10 to run these reports. Does anyone know if it is possible to copy freehand SQL from 'Infomaker' and paste it into Crystal to repliacte the reports?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 29 Mar 2007 at 6:45am
Depending on what type of database you're using on the back-end, you may be able to use a CommandText to set up the SQL.
Go to the DatabaseExpert and connect to your database. If you see "Add Command" under the connection name, you can add command text which is just normal SQL.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum