水晶报告生成eroor [英] crystal report generation eroor

问题描述

con.Open（）;

objRpt = new CrystalReport2（）;

string query =select sr_no as sr_no，gross_wt as gross_wt，core_wt as core_wt，nett_wt如print_list中的nett_wt，其中c_id ='+ Settings.Default.companId +'和batch_code ='+ comboBox2.Text +'和category ='+ comboBox1.Text +';

string query1 =select c_name as c_name from dbo.company_info where c_id ='+ Settings.Default.companId +';

string query2 =select batch_code as batch_code，party_code as party_code，size as as尺寸，厚度为厚度，颜色为颜色，mfg_by为mfg_by来自dbo.batch_enty，其中c_id ='+ Settings.Default.companId +';

尝试

{





SqlDataAdapter adepter = new SqlDataAdapter（query，con）;

SqlDataAdapter adepter1 = new SqlDataAdapter（ query1，con）;

SqlDataAda pter adepter2 = new SqlDataAdapter（query2，con）;

DataSet1 Ds = new DataSet1（）;



adepter.Fill（Ds， DataTable1）;

adepter1.Fill（Ds，DataTable2）;

adepter2.Fill（Ds，DataTable3）;

objRpt.SetDataSource（Ds）;

crystalReportViewer1.ReportSource = objRpt;

}

catch（Exception Ex）

{

MessageBox.Show（Ex.Message）;

}

con.Close（）;

当我评论adepter2.Fill（Ds，D​​ataTable3）时，此代码中的


;

然后Everythin罚款，但batch_enty数据没有显示





但是当我删除评论adepter2.Fill（ Ds，D​​ataTable3）;这个

然后在水晶报告中输入显示从datatable2中提取的双重

con.Open();
objRpt = new CrystalReport2();
string query = "select sr_no as sr_no, gross_wt as gross_wt,core_wt as core_wt,nett_wt as nett_wt from printing_list where c_id='"+Settings.Default.companId+"' and batch_code='"+comboBox2.Text+"' and category='"+comboBox1.Text+"'";
string query1 = "select c_name as c_name from dbo.company_info where c_id='" + Settings.Default.companId + "' ";
string query2 = "select batch_code as batch_code,party_code as party_code,size as size, thickness as thicknes,color as color,mfg_by as mfg_by from dbo.batch_enty where c_id='" + Settings.Default.companId + "' ";
try
{


SqlDataAdapter adepter = new SqlDataAdapter(query, con);
SqlDataAdapter adepter1 = new SqlDataAdapter(query1, con);
SqlDataAdapter adepter2 = new SqlDataAdapter(query2, con);
DataSet1 Ds = new DataSet1();

adepter.Fill(Ds, "DataTable1");
adepter1.Fill(Ds,"DataTable2");
adepter2.Fill(Ds, "DataTable3");
objRpt.SetDataSource(Ds);
crystalReportViewer1.ReportSource = objRpt;
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
con.Close();


in this code when i comment the adepter2.Fill(Ds, "DataTable3");
then everythin fine but batch_enty data not shown


but when i remove as comment adepter2.Fill(Ds, "DataTable3"); this
then entry in crystal report showing double which is extracted form datatable2

推荐答案

嗨...

请参阅此链接以生成Crystal Reports。

http://www.c-sharpcorner.com/UploadFile/manishkdwivedi/create-a-report-using-crystal-report-in-visual-studio-2010/ [ ^ ]

使用Visual Studio 2010中的Crystal Reports生成报告 [ ^ ]

谢谢你。

Hi...
See this links to generate Crystal Reports.
http://www.c-sharpcorner.com/UploadFile/manishkdwivedi/create-a-report-using-crystal-report-in-visual-studio-2010/[^]
Generate a Report using Crystal Reports in Visual Studio 2010[^]
Thank u.

这篇关于水晶报告生成eroor的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！