how to print data from crystal report viewer

Question

0.00/5 (No votes)

See more:

VS2010

Hi
I want to print data from crystal report. I have a button print, on clicking that button 1st report will show then on the crystal report print button it should get printed,but its not working, showing error.

I am attaching the code.

 protected void btnPrint_Click(object sender, EventArgs e)
    {
       ReportDocument cryRpt = new ReportDocument();
            cryRpt.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/ViewAllCrystalReport1.rpt");

            TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            Tables CrTables;

            crConnectionInfo.ServerName = "INSTANCE";
            crConnectionInfo.DatabaseName = "InventoryDatabase";
            crConnectionInfo.UserID = "sa";
            crConnectionInfo.Password = "gariahat";

            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);
    }
}

kindly please help me.

Sudeshna

Posted 3-Feb-15 18:41pm

sudeshna from bangkok

Add a Solution

Comments

/\jmot 4-Feb-15 0:45am

what's the error??

sudeshna from bangkok 4-Feb-15 0:53am

Failed to open the connection.
ViewAllCrystalReport1 {509200AC-ED44-49EC-8695-FEF4E5D50013}.rpt
Details: [Database Vendor Code: 17 ]

error coming in last line cryRpt.PrintToPrinter

sudeshna from bangkok 4-Feb-15 0:57am

Failed to open the connection.
ViewAllCrystalReport1 {509200AC-ED44-49EC-8695-FEF4E5D50013}.rpt
Details: [Database Vendor Code: 17 ]
error coming at the last line.
cryRpt.PrintToPrinter(2,true,1,2)

sudeshna from bangkok 4-Feb-15 1:11am

hello.Can anyone please help me?

Sinisa Hajnal 4-Feb-15 3:05am

Patience, its only been two hours since you posted the question.
Can you print with different parameters in PrintToPrinter? Is the printer set on the report? Can you print on the printer from word or notepad with the same user as the report process uses (maybe the printer is not visible)? Try setting that printer as default too.

sudeshna from bangkok 4-Feb-15 3:47am

sorry.no the printer is not set on the report. how to set that? as i click on print button its showing the error that i posted

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)

InbarBarkai · Accepted Answer · 2015-02-03T23:06:00

Solution 1

Try the following code instead:

C#

public static void SetCrystalConnection(ReportDocument doc)
{
      doc.SetDatabaseLogon("UserName", "Password");
}

If you have subreports with a different connection try:

C#

public static void SetCrystalConnection(ReportDocument doc)
{
    var defaultDbName = "TheDefaultDatabaseName";
    doc.SetDatabaseLogon("UserName", "Password");
    if (!doc.IsSubreport)
        for (int i = 0; i < doc.Subreports.Count.GetIntValue(); i++)
            if (defaultDbName != doc.Subreports[i].DataSourceConnections[0].DatabaseName)
                SetCrystalConnection(doc.Subreports[i]);
}

Posted 3-Feb-15 23:06pm

InbarBarkai

Comments

sudeshna from bangkok 4-Feb-15 5:08am

this code where to add? the code which i wrote shall i erase it?

InbarBarkai 4-Feb-15 5:10am

Instead of it all.
Load the document (like you did).
Then set the connection.
Print

sudeshna from bangkok 2-Mar-15 23:07pm

Hi can you please tell me how to display the print wizard(set up) dialog box at run time after clicking on print button. the code which you had told me its printing all the pages directly after clicking on print button. But i want to mention specific pages in the print set up page or printer name after clicking on print button

InbarBarkai 2-Mar-15 23:34pm

If you're not displaying the report through a viewer, the only option you have is to display a PrintDialog and use cr.PrintOptions.CopyFrom to copy the options to the crystal reports.

This solution, altough it probably works, is very buggy and might not accept the new options.
Crystal Reports printing is very annoying and the only way it prints perfectly is through a viewer, when everything is handled inside the Crystal Reports API.

If all you want is to choose the pages you want to print, show a dialog of your own, asking for the pages.
Then print them using the print method.

Best of luck

sudeshna from bangkok 2-Mar-15 23:40pm

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument rDoc = new ReportDocument();
rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/StockCrystalReport1.rpt");
rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
//this.crystalReportViewer.ReportSource = rDoc;
//this.crystalReportViewer.DataBind();
//this.crystalReportViewer.Focus();
//rDoc.Refresh();

rDoc.PrintToPrinter(1, true, 0, 0);
}

This is the code that you had told. and I was using it for so many days

sudeshna from bangkok 2-Mar-15 23:42pm

Now what code to write, Can you please help me?

sudeshna from bangkok 3-Mar-15 0:36am

Hello, Please can you help me? Please.

sudeshna from bangkok 4-Feb-15 5:11am

i dont have any subreports. the 1st line where to add in my code?

sudeshna from bangkok 4-Feb-15 5:12am

which lines to be removed can you please say? sorry to bothere. if you could mention it

InbarBarkai 4-Feb-15 5:21am

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/ViewAllCrystalReport1.rpt");

cryRpt .SetDatabaseLogon("UserName", "Password");

cryRpt.Refresh();
cryRpt.PrintToPrinter(2, true, 1, 2);
}
}

sudeshna from bangkok 4-Feb-15 5:34am

Thanks a lot.

sudeshna from bangkok 4-Feb-15 21:53pm

Hi InbarBarkai

Can i ask another thing? i have a drop down combo box for products like earrings,necklace,bangles etc.

if i click from the drop down any of the above products, that particular details show in gridview, now i want to print that details which are there in gridview, now the code for print is not working here.

i mean selection based on category. can you tell me please how to do so?

InbarBarkai 4-Feb-15 23:35pm

Please show me the code so I can have a look

sudeshna from bangkok 4-Feb-15 23:59pm

private DataSet GetAllJewellery()
{
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spGetJeweleryOnSoldItems", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = ddlCategory.SelectedItem.Text;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
return ds;
}
}
}

protected void btnPrint_Click(object sender, EventArgs e)
{
SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter getAllJewellerySoldItems = new SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter();
DataTable dt = getAllJewellerySoldItems.GetAllJewellerySoldItems(this.ddlCategory.SelectedValue);
ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldItemsCrystalReport.rpt"));
rDoc.SetDataSource(dt);
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();
}
}

InbarBarkai 5-Feb-15 0:01am

You void the change that I suggested when you replace the data source of the report.
Try instead of setting the data source, just changing the selection formula of the report.

sudeshna from bangkok 5-Feb-15 0:05am

didnt get it. last time what you suggested there no drop down list was there, so the other asp forms worked. as i wanted to display all the records.
but this time gridview will show data based on choosing from drop down list and that list should show in crystal report and clicking on print button it should directly print.

InbarBarkai 5-Feb-15 0:07am

The code:
SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter getAllJewellerySoldItems = new SoldItemsDataSetTableAdapters.spGetJeweleryOnSoldItemsTableAdapter();
DataTable dt = getAllJewellerySoldItems.GetAllJewellerySoldItems(this.ddlCategory.SelectedValue);
ReportDocument rDoc = new ReportDocument();
rDoc.SetDataSource(dt);
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);

overrides the data source of the report. The crystal report already holds within itself a query, all you need to do is set the parameter.

sudeshna from bangkok 5-Feb-15 0:06am

how to do so? can you please help? you helped me last time, it worked. thank u so much. can you please tell me?

sudeshna from bangkok 5-Feb-15 0:14am

i have to set the parameter in the crystal report?

sudeshna from bangkok 5-Feb-15 0:16am

how to do so? or if you want you can change the code and tell me the correct way without using datasource

InbarBarkai 5-Feb-15 0:29am

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldItemsCrystalReport.rpt"));
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("UserName", "Password");
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();
}
}

sudeshna from bangkok 5-Feb-15 0:43am

showing error in rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

InbarBarkai 5-Feb-15 0:44am

Make sure the parameter exists in the report and expects the type of value your assigning it

sudeshna from bangkok 5-Feb-15 0:45am

yes the parameter Category is there in the report

InbarBarkai 5-Feb-15 0:47am

Try
var paramDiscreteValue = new ParameterDiscreteValue { Value = Value };
doc.ParameterFields[ParName].CurrentValues.Add(paramDiscreteValue);

sudeshna from bangkok 5-Feb-15 0:53am

rDoc.Load(Server.MapPath("SoldItemsCrystalReport.rpt"));

in this line do i have to give the full path? as its still showing error at runtime but when i am checking from inside the crystal report that is Main report Preview its working fine. asking for category value and as i am entering earrings, data are showing in crystal report but at runtime, its showing error

InbarBarkai 5-Feb-15 0:55am

The method Load requires a full path.
The result of Server.MapPath is a full path of the relative path you've given it.
Make sure that the report actually is at the location Server.MapPath returns.

sudeshna from bangkok 5-Feb-15 0:54am

where to add these two lines? didnt get it?

sudeshna from bangkok 5-Feb-15 0:55am

ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldCrystalReport.rpt"));
rDoc.SetParameterValue("Category", this.ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();
var paramDiscreteValue = new ParameterDiscreteValue { Value = Value };
doc.ParameterFields[ParName].CurrentValues.Add(paramDiscreteValue);

like this?
and in place of value what do i write?

InbarBarkai 5-Feb-15 0:57am

ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("SoldCrystalReport.rpt"));
var paramDiscreteValue = new ParameterDiscreteValue { Value = this.ddlCategory.SelectedValue};
rDoc.ParameterFields["Category"].CurrentValues.Add(paramDiscreteValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
this.crystalReportViewer.ReportSource = rDoc;
this.crystalReportViewer.DataBind();
this.crystalReportViewer.Focus();

sudeshna from bangkok 5-Feb-15 0:57am

C:\Users\SUDESHNA\Documents\Visual Studio 2010\Projects\Inventory\SoldCrystalReport.rpt

this is the full path where my report is there

sudeshna from bangkok 5-Feb-15 0:58am

Then shall i remove Server.MapPath?

sudeshna from bangkok 5-Feb-15 1:05am

what namespace to add? it showing error in line ParameterDiscreteValue

sudeshna from bangkok 5-Feb-15 1:12am

Object reference not set to an instance of an object. this error showing in line
rDoc.ParameterFields["Category"].CurrentValues.Add(paramDiscreteValue);

InbarBarkai 5-Feb-15 2:19am

Is there a selected value for the DropDownList?
Does the parameter exists in the ParameterFields?

sudeshna from bangkok 5-Feb-15 2:30am

yes the parameter category exists in the parameter field. see on clicking on any of the 5 items from drop down list, the list gets populated in gridview.

can i share a screenshot? how to do that?

InbarBarkai 5-Feb-15 2:32am

Check if rDoc.ParameterFields["Category"] is null or rDoc.ParameterFields["Category"].CurrentValues is null

sudeshna from bangkok 5-Feb-15 2:51am

how to check that? shall i recreate the parameter field again? i think my parameter value is not set properly. beside category a ? sign showing in parameter field [?]@Category like this showing. is it correct?

sudeshna from bangkok 5-Feb-15 3:11am

i checked from crystal report main report preview.from there data is showing.

InbarBarkai 5-Feb-15 3:33am

Sudeshna,
I feel like I'm going over the basic usage of visual studio and C# programming.
Please google it a little, especially about the usage of the visual studio debugger.
Then read about the exception "Object reference is not set to an instance of an object".

After you mastered those stuff, revisit the usage of the Crystal Reports api for .Net.

sudeshna from bangkok 5-Feb-15 3:40am

i checked by debugging. sorry that time didnt understand. I know how to debug. rDoc.ParameterFields["Category"] is showing a value earrings whatever i have selected from drop down

sudeshna from bangkok 5-Feb-15 4:15am

protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument rDoc = new ReportDocument();
rDoc.Load("C:/Users/SUDESHNA/Documents/Visual Studio 2010/Projects/Inventory/SoldCrystalReport.rpt");
rDoc.SetParameterValue("@Category", ddlCategory.SelectedValue);
rDoc.SetDatabaseLogon("sa", "gariahat");
//this.crystalReportViewer.ReportSource = rDoc;
//this.crystalReportViewer.DataBind();
//this.crystalReportViewer.Focus();
rDoc.Refresh();
rDoc.PrintToPrinter(1, true, 0, 0);
}

i have now changed the code to this. please can you help me.

sudeshna from bangkok 5-Feb-15 4:54am

Please dear help me. minor thing is left. if you help me a bit it might work.