Printing Bill using Crystal Reports

Chidiebere Mgbemena

6y1.2kLearn iOS Programming

I tried to print bills through Crystal Reports but it is coming out blank.

any suggestions will be appreciated.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
namespace NSPM_Sales_Invoice
{
public partial class PrintBills : Form
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.NSPM_Sales_InvoiceCon);
ReportDocument Cryrpt = new ReportDocument();
SqlDataAdapter dr;
public PrintBills()
{
InitializeComponent();
}
private void PrintBills_Load(object sender, EventArgs e)
{
txtJobNo.Text = Class1.strinv;
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer, Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo = '" + txtJobNo.Text + "'", con);
DataSet dst = new DataSet();
da.Fill(dst, "PrintBills");
Cryrpt.Load("PrintBill.rpt");
Cryrpt.SetDataSource(dst);
crystalReportViewer1.ReportSource = Cryrpt;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

zeeshan akram6y ago
I have same problem then I solve it as follows:

1. Copy crystalreportviewers13 foler from C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319 to Project folder ROOT.

2. Copy this in Web.config:
     "businessObjects">
         "crystalReports">
               "rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"/>
               "crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />



........................



          "true" />


          "ResourceUri" value="/crystalreportviewers13" />
0
Chidiebere Mgbemena6y ago
Laxmidhar, thank you for pointing this out, I was missing (.table[0]); in my datasource argument its all sorted out and working now. Thank you again.
0
Laxmidhar Sahoo6y ago
1- check your query
string query = "select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer, Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo = '" + txtJobNo.Text + "'";

2- the query variable output copy and pest in the sql server query window .check the result.
setdatasource argument shoud be a data table
3- Cryrpt.SetDataSource(dst.table[0]);
+1
Chidiebere Mgbemena6y ago
Hi Amit, What report are you talking about? My SQL query is not fetching data from table. That's the problem
0
Amit Gupta6y ago
Have you designed your report with the same datasource that you are getting from your query? As your sql query has rows but not in report. Please re-check that again.

update:
Is your query giving any error? As your query is having where clause with a job no., is there any data respective to that claus

If Yes and data is still not showing then I suggest you to build query using SQL Query builder (Ctrl + Shift +Q)-> Add tables -> select required columns and at last add your where clause.

Do try the above and let me know, if it solves your issue.
0
Chidiebere Mgbemena6y ago
Hi Jignesh,

here are the Datas for both HeadData and RowData. pease put them in sql query format that can pull data from the two tables.

thank you.

Table HeaderData

Table RowData

0
Jignesh Kumar6y ago
Hi Mgbemena,

What are the data coming from header table. If you are using inner join then in both table jobNo should be there then only it will return data. Check your data in both tables if job number available in both then it will work.

Why header table is used? it is for header only or it has other data as well. You can use left join instead of inner join.
0
Chidiebere Mgbemena6y ago
My select statement is not returning data, I have checked but can't see why. Please check my select statement to see if it is well arranged
0
Jignesh Kumar6y ago
Hi,

Did you check your select statement is returning data and dataset is filled up with data.? Put debugger and try to check dataset values. Your code looks good me.
0