Crystal Reports Tutorial Creating SQL Commands Business Objects Training Lesson 17.2
Why Stack Overflow recommends it
Stack Overflow users link it when someone needs to write a raw SQL query or parameterized command inside a Crystal Report instead of using the table wizard.
Recommended by 3 people across 4 different months, 2013 to 2013.
What it is
A seven-minute TeachUComp tutorial from 2009 that shows how to create a SQL command object in Crystal Reports by Business Objects. It is lesson 17.2 in the company's Crystal Reports course and walks through the dialog on screen.
What people said
Recommends CoSpringsGuy · 2013-04 · Stack Overflow · on “Crystal Reports : Bad Date format string error”
here is a quick video I found that can get you started [this video] You will need to know a little about your SQL syntax but there should be plenty of good reference for that. To convert your date you will need to see how your syntax handles things in comparison to the example I posted above to convert the string into a date
Recommends David - · 2013-06 · Stack Overflow · on “How do I use Sql Queries in Crystal Report?”
Ok, lets see how you can achieve that for example in VB.NET. (If you are using a version of Visual Studio.NET greater than 2008, download and install Crystal Reports first since it's not embedded.) Open Visual Studio.NET. Create a new WindowsForms application by clicking, File -> New Project -> Visual Basic - Windows Forms Application. In the case of Visual Studio.NET 2010, you must change the .NET Framework of your project to .NET Framework 4 (not Client Profile) so you can find the Crystal Reports Viewer in the Reporting tab of the Toolbox. Drag and drop from the Toolbox a TextBox, a Button and a CrystalReportsViewer onto the form. The first 2 are located in the Common Controls tab and the
Recommends David - · 2013-07 · Stack Overflow · on “binding relational data to crystal Report / xtraReport”
You don't need a table adapter, just create a database connection inside the report document and add the SQL query inside a command. For more info check this [this video]
Recommends ca_wan · 2013-10 · Stack Overflow · on “Pass Crystal parameter from main report to command object”
If you are using an SQL command, don't create the parameters in the main report. The window where you put your SQL has a section called Parameter List. Create all your parameters relating to the query there and it will be transfered to the main report. In your coding you have {?Area}, create a parameter with the name Area. I found a video demonstrating it. It's an old version of Crystal Reports but still works the same. [this video]