public void rmReport() { string planningDate = dateTimePickerHead.Value.ToString("yyyyMMdd"); productCategory = cmbProductGroup.Text.Substring(3, 10); rptViewer rptViewer = new rptViewer(); DataSet dsGeneral = new DataSet(); RMTransfer objRpt = new RMTransfer(); //rptRM objRpt = new rptRM(); string strSql = "select * from RM_View where trandate='" + planningDate + "' and category='" + productCategory + "'"; dsGeneral = dataProvider.getDataSet(strSql, "RM_View", "TCPL"); objRpt.SetDataSource(dsGeneral); objRpt.VerifyDatabase(); rptViewer.crystalReportViewer.ReportSource = objRpt; rptViewer.Refresh(); rptViewer.Show(); }
public void rmReport() { string planningDate = dateTimePickerHead.Value.ToString("yyyyMMdd"); productCategory = cmbProductGroup.Text.Substring(3, 10); rptViewer rptViewer = new rptViewer(); DataSet dsGeneral = new DataSet(); RMTransfer objRpt = new RMTransfer(); string strSql = "select *, ISNULL((select sum(extcost) from ICADED where ITEMNO = T_PCTRN.ITEMNO " + "and rtrim(MANITEMNO) = T_PCTRN.TRANDATE and COMMENTS = 'RMT-" + productCategory + "'),'0') " + "as TRANCOST, ISNULL((select sum(extcost) from ICADED where ITEMNO = T_PCTRN.ITEMNO and rtrim(MANITEMNO) = T_PCTRN.TRANDATE and COMMENTS = 'RMR-" + productCategory + "'),'0') " + "as RTNCOST from T_PCTRN where TRANDATE = '" + planningDate + "' and ITEMTYPE = 'RM' and ITEMNO <> '15502-05' AND CATEGORY = '" + productCategory + "' ORDER BY ITEMNO"; dsGeneral = dataProvider.getDataSet(strSql, "T_PCTRN", "TCPL"); objRpt.SetDataSource(dsGeneral); objRpt.VerifyDatabase(); rptViewer.crystalReportViewer.ReportSource = objRpt; rptViewer.Refresh(); rptViewer.Show(); }