tags:

views:

19

answers:

1
+1  Q: 

Supplying my own Query Statement - Can it be done?

I am creating a Crystal 2008 report, and I'd like to provide it a T-SQL statement for data generation, instead of selecting and joining together tables. Can this be done?

+3  A: 

Yes. In the Database Expert, after picking your connection, instead of choosing your tables, select "Add Command" and type your query in there.

SarekOfVulcan  2010-05-10 15:09:59

related questions

Dynamically change an image in a Crystal Report at runtime
Change the Catalog property of a Crystal Report in VS 2005
Crystal Reports .Net Guidance
VS 2003 CrystalReports - details section problem
Where can I get a list of what Crystal Reports features conflict?
VB6 / Crystal Report 8.5 error: A string is required here
Merge Modules for Crystal Reports 2008 - Needs a Keycode?
Crystal Reports and LINQ
VB.NET 2005 problems with Designer not being able to process a code line.
How do you detect and print the current drilldown in the CrystalReportViewer control?
How do I query the CrystalReports CMS database?
Crystal Reports 2008 InprocServer + TempDir = "Operation not yet implemented"
Crystal Report icons/toolbar not working when deployed on web server
Using MySQL on Visual Studio 2008
XML dataset in Crystal Reports
Replace a database connection for report and all subreports
Is it okay to have a lot of database views?
How to handle variable width FieldObjects in Crystal Reports
"File Save Failed" error when working with Crystal Reports in VS2008
Summary fields in Crystal Report VS2008
Broken chart images in Crystal Reports in web application
What's the best way of diffing Crystal Reports?
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
.NET 3.5 SP1 and aspnet_client Crystal Reports
Is there some way of recycling a Crystal Reports dataset?