SQL on Crystal report
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=370
Printed Date: 04 Apr 2025 at 4:59am
Topic: SQL on Crystal report
Posted By: shamee_banu
Subject: SQL on Crystal report
Date 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
|
Replies:
Posted By: hilfy
Date 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.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: BrianBischof
Date 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>
|
|