Advertisement

05.15.2008 at 08:26AM PDT, ID: 23405548
[x]
Attachment Details

automatically print a crystal report from c# .net for windows

Asked by KS_Mis in .NET, Microsoft Visual C#.Net

Tags: microsoft, c# .net crystal

I'd like to simply load a crystal report, pass in parameters, and print.  I tried PrintToPrinter, but I got a database login failed and from research it seems that I have to set the printer which could be anything.  So I pulled in a report viewer, but when i call PrintReport, a dialog comes up.  I simply want to loop through repair orders and print a report for each one with no user interaction required.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

private void PrintTag(string ro)
        {
            CrystalDecisions.Shared.ConnectionInfo connectionInfo = new
              CrystalDecisions.Shared.ConnectionInfo();
            connectionInfo.IntegratedSecurity = true;
            connectionInfo.DatabaseName = RPCSShipping.Program.Database;
            connectionInfo.ServerName = RPCSShipping.Program.Server;
            connectionInfo.UserID = RPCSShipping.Program.UserID;
            connectionInfo.Password = RPCSShipping.Program.Password;
 
            reportDocument1.Load(Application.StartupPath + "\\Tag.rpt");
 
            CrystalDecisions.CrystalReports.Engine.Tables tables = reportDocument1.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
            {
                CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
                tableLogonInfo.ConnectionInfo = connectionInfo;
                table.ApplyLogOnInfo(tableLogonInfo);
            }
 
            reportDocument1.SetParameterValue("@Company_Code", "''");
            reportDocument1.SetParameterValue("@RO", ro);
 
            crystalReportViewer1.ReportSource = reportDocument1;
            crystalReportViewer1.PrintReport();
            //reportDocument1.PrintOptions.PrinterName = "";
            //reportDocument1.PrintToPrinter(1, true, 1, 1);
        }
[+][-]05.15.2008 at 10:19AM PDT, ID: 21576032

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:28AM PDT, ID: 21576141

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: .NET, Microsoft Visual C#.Net
Tags: microsoft, c# .net crystal
Sign Up Now!
Solution Provided By: KS_Mis
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628