Print Page | Close Window

Is it Possible to Create Report from Sql Query

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1855
Printed Date: 18 May 2024 at 12:48pm


Topic: Is it Possible to Create Report from Sql Query
Posted By: vijay sandoria
Subject: Is it Possible to Create Report from Sql Query
Date Posted: 08 Dec 2007 at 11:17am
Is it Possible to Create Report from Sql Query?
 
just like
 
Select * from Table1;
 
 
or from an type of SQL query?


Replies:
Posted By: BrianBischof
Date Posted: 08 Dec 2007 at 1:30pm
Yes, you can add a command object to your report and put any SQL you like in it. Then the report uses the resulting data to print your report. This is found on the Data tab of the Database Expert. Click on the Add Command node under your current connection.

If you want to find expert tricks for optimizing your report for SQL and writing custom SQL statements, check out chapter 10 and 11 in my book http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Crystal Reports Encyclopedia . You'll be surprised at all the great stuff I packed into two chapters.

-------------
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>

Posted By: vijay sandoria
Date Posted: 12 Dec 2007 at 11:28am

i m using .net version i have never found this data tab can u plz explain in steps i will b very thank full to u



Print Page | Close Window