通过压延机生成水晶报告 [英] crystal report through calender

问题描述

如何在日历的帮助下通过Crystal Report从SQlServer数据库查看数据? (注意:查看月度销售报告)

How to view data from SQlServer database through Crystal Report with the help of calender? (note: To view Monthly sales report)

推荐答案

if(flag == true)
{
ReportDocument doc = new ReportDocument();
PaySlip.monthwisesalaryDataTable saldetails =新的PaySlip.monthwisesalaryDataTable();
PaySlipTableAdapters.monthwisesalaryTableAdapter广告=新的PaySlipTableAdapters.monthwisesalaryTableAdapter();
ad.Fill(saldetails);
DataSet ds = new DataSet();
ds.Tables.Add(saldetails);
字符串str;
str = Server.MapPath(〜\\ CrystalReports \\");
doc.Load(str +"PaySlipReport.rpt");
doc.SetDataSource(ds);
CrystalReportViewerPaySlip.ReportSource = doc;
CrystalReportViewerPaySlip.SelectionFormula ="{monthwisesalary.intdoctorId} =" + ddlemployeeid.Text +和{monthwisesalary.intsalaryformonth} =" + ddlsalarymonth.Text +和{monthwisesalary.intsalaryforyear} =" + ddlsalaryyear.Text +"/> CrystalReportViewerPaySlip.DataBind();
clear();
}
其他
lblmsg.Text =";

if (flag == true)
{
ReportDocument doc = new ReportDocument();
PaySlip.monthwisesalaryDataTable saldetails = new PaySlip.monthwisesalaryDataTable ();
PaySlipTableAdapters.monthwisesalaryTableAdapter ad = new PaySlipTableAdapters.monthwisesalaryTableAdapter();
ad.Fill(saldetails);
DataSet ds = new DataSet();
ds.Tables.Add(saldetails);
string str;
str = Server.MapPath("~\\CrystalReports\\");
doc.Load(str + "PaySlipReport.rpt");
doc.SetDataSource(ds);
CrystalReportViewerPaySlip.ReportSource = doc;
CrystalReportViewerPaySlip.SelectionFormula = "{monthwisesalary.intdoctorId}= " + ddlemployeeid.Text + " and {monthwisesalary.intsalaryformonth}=" + ddlsalarymonth.Text + " and {monthwisesalary.intsalaryforyear}=" + ddlsalaryyear.Text + " ";
CrystalReportViewerPaySlip.DataBind();
clear();
}
else
lblmsg.Text = "";

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