Not able to take print from CrystalReports through Programatically in asp.net

Question

0.00/5 (No votes)

See more:

, +

C#

protected void BtnApprove_Click(object sender, EventArgs e)
        {
            ReportDocument cryPrntRpt;
            cryPrntRpt = new ReportDocument();
            cryPrntRpt.Load(Server.MapPath("~\\CrReports\\CrPrintReport.rpt"));
            cryPrntRpt.SetDatabaseLogon("UNM", "PWD", @"SRVNM", "MYDB");

            cryPrntRpt.PrintToPrinter(1, false, 0, 0);


            try
            {
                ExportOptions CrExportOptions;
                DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
                PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
                cryPrntRpt.PrintToPrinter(1, false, 0, 0);
                CrDiskFileDestinationOptions.DiskFileName = "D:\\PDF\\" + Regno.ToString() + ".PDF";
                CrExportOptions = cryPrntRpt.ExportOptions;
                {
                    CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
                    CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
                    CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
                    CrExportOptions.FormatOptions = CrFormatTypeOptions;
                }
                cryPrntRpt.Export();
            }
            catch (Exception ex)
            {
                //Message(ex.ToString());
            }
            con.Close();
    }

Iam not getting any print from my printer (VS2010,windows 8.1,SAP Crystal reports for VS2010). Please Help Me.

Posted 1-Jan-15 22:18pm

Member 10989312

Updated 2-Jan-15 9:18am

Kschuler

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dilan Shaminda · Answer 1 · 2015-01-02T02:16:00

Solution 1

I don't see any code segment which is binding data to crystal report.You have to bind your data to report DataSource.Here is a good tutorial you to follow

Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

Posted 2-Jan-15 2:16am

Dilan Shaminda

Comments

Member 10989312 3-Jan-15 1:13am

Report is showing on pageload and it is also exporting to pdf, after displaying the report on button click event (Approve Button) i want to take printout.

protected void Page_Load(object sender, EventArgs e)
{

ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = "SRVNM";
myConnectionInfo.DatabaseName = "MYDB";
myConnectionInfo.UserID = "UNM";
myConnectionInfo.Password = "PWD";
setDBLOGONforREPORT(myConnectionInfo);
}

private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
{
TableLogOnInfos mytableloginfos = new TableLogOnInfos();
mytableloginfos = CrystalReportViewer1.LogOnInfo;
foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
{
myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
}
//ReportDocument cryPrntRpt;
cryPrntRpt = new ReportDocument();
cryPrntRpt.Load(Server.MapPath("~\\CrReports\\CrPrintReport.rpt"));
cryPrntRpt.SetDatabaseLogon("UNM", "PWD", @"SRVNM", "MYDB");

}

Dilan Shaminda 3-Jan-15 1:19am

You can use PrintToPrinter method

ex:

System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
rptDoc.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
rptDoc.PrintToPrinter(1, true, 0, 0);

Member 10989312 3-Jan-15 1:38am

i tried with the above code, problem not sloved...i am not getting any error also...

Dilan Shaminda 3-Jan-15 1:48am

what is the error you are getting?put printing code after you export it to pdf

Member 10989312 3-Jan-15 2:03am

i am not getting any error... in the button click event after print code i am exporting to pdf, and the pdf file is storing on d:\pdf folder successfully.

protected void BtnApprove_Click(object sender, EventArgs e)
{
ReportDocument cryPrntRpt;
cryPrntRpt = new ReportDocument();
cryPrntRpt.Load(Server.MapPath("~\\CrReports\\CrPrintReport.rpt"));
cryPrntRpt.SetDatabaseLogon("UNM", "PWD", @"SRVNM", "MYDB");

cryPrntRpt.PrintToPrinter(1, false, 0, 0);

try
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
cryPrntRpt.PrintToPrinter(1, false, 0, 0);
CrDiskFileDestinationOptions.DiskFileName = "D:\\PDF\\" + Regno.ToString() + ".PDF";
CrExportOptions = cryPrntRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cryPrntRpt.Export();
}
catch (Exception ex)
{
//Message(ex.ToString());
}
con.Close();
}

Dilan Shaminda 3-Jan-15 2:08am

put print code after cryPrntRpt.Export(); line
and see whether you are getting any exception.You catch the exception but you do nothing.Put a brake point there and see is there any exception or not.Remove this line cryPrntRpt.PrintToPrinter(1, false, 0, 0);

and i don't see that you have included direct printing code
put this after cryPrntRpt.Export();

System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
rptDoc.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
rptDoc.PrintToPrinter(1, true, 0, 0);

Member 10989312 3-Jan-15 4:38am

i placed the code after report export line, it was showing that the printer name as "Send To OneNote 2013" and there is no exception.

Dilan Shaminda 3-Jan-15 10:42am

yes.OneNote is set as the default printer.you can give any printer name connected to the computer. replace printDocument.PrinterSettings.PrinterName with your printer name.if you don't have a printer you can install a virtual printer like Bullzip pdf printer and test it