How to use Crystal Reports in your project

How to use Crystal Reports in your projects

It was a problem finding how we to print reports using Crystal Reports, but I will tell you how. Visual Studio .NET supports Crystal Reports and you can use it easily from there.

Follow me:

1. Create a new C# .NET or VB.NET Windows Application project.
2. With the .NET toolbox, design your project as in this figure:



3. You need a TextBox, a Button, and a CrystalReportViewer object in your project.
4. Be sure that your SQL Server connection is started, then connect to your SQL Server and use the PUBS tables in your project.
5. Now generate your dataset object.
6. Right click on your project name in Solution Explorer and choose Add New Item, as in this figure:



7. Now find the Crystal Report item and add it to your project.



8. After you do that, you must configure your report.



9. In the standard report creation wizard, select your dataset in the Project Data option. Select the AUTHORS table and add it to the selected table part.



10. In the next step, select the fields you want to print and add it to the right part and click on the Finish button.



11. Form your Toolbox, choose the Report Document object from the Component part and apply its setting.





12. You are ready for coding your project. For the Click event of the button, write this code:

//Filling dataset with Authors table data.
dataAdapter.Fill(myDataSet.authors);
//Setting dataset tables to the crystal report document object.
crystalReport11.SetDataSource(myDataSet.authors);
//Telling to the report viewer, what is my report document.
crystalReportViewer1.ReportSource = crystalReport11;
//Or you can directly send your report to the printer with this line.
//In this case , you don't need a ReportViewer in your project.
/*crystalReport11.PrintToPrinter(1,true,0,1);*/

That's all. That was really easy!!

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)