public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptParentCategory rpt = new rptParentCategory(); rpt.Site = this.Site; return(rpt); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptParentCategory rpt = new rptParentCategory(); rpt.Site = this.Site; return rpt; }
private void CollectParentCategory() { try { String sqlCommand = SqlQueries.GetQuery(Query.ViewParentCategory); CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>(); String tempConnStr = oTempDal.ConnectionString; // Create a new data adapter based on the specified query. SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCommand, tempConnStr); SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter); DataTable parentCategory = new DataTable(); parentCategory.Locale = System.Globalization.CultureInfo.InvariantCulture; dataAdapter.Fill(parentCategory); rptParentCategory objParentCategory = new rptParentCategory(); objParentCategory.SetDataSource(parentCategory); string reportHeader = RMSAdminController.CollectHeader(); string reportFooter = RMSAdminController.CollectFooter(); objParentCategory.SetParameterValue(0, reportHeader); objParentCategory.SetParameterValue(1, reportFooter); dataAdapter.Dispose(); RecportViewerCtl objRptViewer = new RecportViewerCtl(this); objRptViewer.cRptViewerAdmin.ReportSource = objParentCategory; pnlContext.Controls.Clear(); objRptViewer.Parent = this; pnlContext.Controls.Add(objRptViewer); objRptViewer.Dock = DockStyle.Fill; } catch (Exception exp) { throw exp; } }