How to print Crystal Reports in C#

The following program shows how to print multiple copies of Crystal reports from C#.

All C# Crystal Reports Tutorial in this website is based on the following database - crystaldb. So before you begin this section , please take a look at the database structure of crystaldb - Click Here C# crystaldb

If you are new to Crystal Reports and do not know how to create Crystal Reports from C# , please take a look at the section step by step tutorial for creating a Crystal Reports from C#.

The following program generate a Crystal Reports from product table and print 2 copies of report without using CrystalReportViewer in C#. The program generate report from Product table , the step by step tutorial for creating a Crystal Reports from C# section explains how to create report from Product table. Also the program dynamically passing the logon parameters to Crystal Report. If you don't know how to pass dynamic logon parameter please take a look at the section C# Dynamic logon parameters in Crystal Reports.

Hope you understand the previous section well. Create a Crystal report from Product Table and copy and paste the following source code in the project.

Copy and paste the following source code and run your C# project.

Full Source C#
using System; using System.Windows.Forms; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt"); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = "YOUR SERVERNAME"; crConnectionInfo.DatabaseName = "DATABASE NAME"; crConnectionInfo.UserID = "USERID"; crConnectionInfo.Password = "PASSWORD"; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cryRpt.Refresh(); cryRpt.PrintToPrinter(2, true, 1, 2); } } }

cryRpt.Load(PUT CRYSTAL REPORT PATH HERE\\CrystalReport1.rpt");

The Crystal Reports file path in your project files location, there you can see CrystalReport1.rpt . So give the full path name of Crystal Reports file like c:\projects\crystalreports\CrystalReport1.rpt

crConnectionInfo.ServerName = "YOUR SERVERNAME";

crConnectionInfo.DatabaseName = "DATABASE NAME";

crConnectionInfo.UserID = "USERID";

crConnectionInfo.Password = "PASSWORD";

You have to pass the necessary database connection information.

Now you can run the program . When you run this program the program will print multiple copies of Crystal Reports.






Related Topics
  1. C# Crystal Reports sample databse
  2. C# Crystal Reports step by step
  3. C# Crystal Reports from multiple tables
  4. C# Crystal Reports String parameter
  1. C# Crystal Reports Integer parameter
  2. C# Crystal Reports Date parameter
  3. C# Crystal Reports Dynamic Logon parameters
  4. C# Crystal Reports Formula Field
  5. C# Crystal Reports Summary Field
  6. C# Crystal Reports Export to Pdf
  7. C# Crystal Reports Export to Excel
  8. Email Crystal Reports from C# Application
  9. C# Crystal Reports without database
  10. C# Crystal Reports from SQL Query
  11. Dynamic Crystal Reports from C# Application
  12. C# Crystal Reports from XML
  13. C# Crystal Reports - sub reports
  14. C# Crystal Reports - on demand sub reports
  15. C# Crystal Reports - Date to Date
  16. How to deploy Crystal Report
  17. How to Crystal Report Merge Module