Topic: SQL on Crystal report Posted: 20 Mar 2007 at 11:44pm
i want to create SQL command in the crystal report but once i logon to my database i could not find the "Add Commands opption" ..... how do i do that..... i am using Crystal Report X1 please help me
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 21 Mar 2007 at 9:58am
Go to the Database Expert. On the left hand side, find the database you've logged in to and you should see "Add Command" as the first entry under the database name.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 21 Mar 2007 at 10:36am
Also, some databases don't allow you to add commands if you use their native database driver. But if you use an ODBC connection then they will let you. Of course, SQL Server allows this and you should see it where Deld mentions it. But if you have a less common database then you might not be able to do it.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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
IP Logged
