public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptProductStatisticsMinimumLevel rpt = new crptProductStatisticsMinimumLevel(); rpt.Site = this.Site; return(rpt); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptProductStatisticsMinimumLevel rpt = new crptProductStatisticsMinimumLevel(); rpt.Site = this.Site; return rpt; }
/// <summary> /// Function to print ProductStatisticsReport in curresponding Crystal report /// </summary> /// <param name="dsProductStatistics"></param> /// <param name="strLevels"></param> internal void ProductStatisticsReport(DataSet dsProductStatistics, string strLevels) { try { crptProductStatisticsReport crptProductStatisticsReport = new crptProductStatisticsReport(); crptProductStatisticsFastMoving crptProductStatisticsFastMoving = new crptProductStatisticsFastMoving(); crptProductStatisticsMaximumLevel crptProductStatisticsMaximumLevel = new crptProductStatisticsMaximumLevel(); crptProductStatisticsMinimumLevel crptProductStatisticsMinimumLevel = new crptProductStatisticsMinimumLevel(); crptProductStatisticsNegativeStock crptProductStatisticsNegativeStock = new crptProductStatisticsNegativeStock(); crptProductStatisticsReorderLevel crptProductStatisticsReorderLevel = new crptProductStatisticsReorderLevel(); crptProductStatisticsSlowMoving crptProductStatisticsSlowMoving = new crptProductStatisticsSlowMoving(); crptProductStatisticsUnUsed crptProductStatisticsUnused = new crptProductStatisticsUnUsed(); foreach (DataTable dtbl in dsProductStatistics.Tables) { if (dtbl.TableName == "Table") { if (strLevels == "Minimum Level") { crptProductStatisticsMinimumLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "Maximum Level") { crptProductStatisticsMaximumLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "Negative Stock") { crptProductStatisticsNegativeStock.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "Reorder Level") { crptProductStatisticsReorderLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "UnUsed") { crptProductStatisticsUnused.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "Fast Movings") { crptProductStatisticsFastMoving.Database.Tables["dtblCompany"].SetDataSource(dtbl); } if (strLevels == "Slow Movings") { crptProductStatisticsSlowMoving.Database.Tables["dtblCompany"].SetDataSource(dtbl); } } else if (dtbl.TableName == "Table1") { if (strLevels == "Minimum Level") { crptProductStatisticsMinimumLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "Maximum Level") { crptProductStatisticsMaximumLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "Negative Stock") { crptProductStatisticsNegativeStock.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "Reorder Level") { crptProductStatisticsReorderLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "UnUsed") { crptProductStatisticsUnused.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "Fast Movings") { crptProductStatisticsFastMoving.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } if (strLevels == "Slow Movings") { crptProductStatisticsSlowMoving.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl); } } } if (strLevels == "Minimum Level") { this.crptViewer.ReportSource = crptProductStatisticsMinimumLevel; } if (strLevels == "Maximum Level") { this.crptViewer.ReportSource = crptProductStatisticsMaximumLevel; } if (strLevels == "Negative Stock") { this.crptViewer.ReportSource = crptProductStatisticsNegativeStock; } if (strLevels == "Reorder Level") { this.crptViewer.ReportSource = crptProductStatisticsReorderLevel; } if (strLevels == "UnUsed") { this.crptViewer.ReportSource = crptProductStatisticsUnused; } if (strLevels == "Fast Movings") { this.crptViewer.ReportSource = crptProductStatisticsFastMoving; } if (strLevels == "Slow Movings") { this.crptViewer.ReportSource = crptProductStatisticsSlowMoving; } SettingsSP spSettings = new SettingsSP(); if (spSettings.SettingsStatusCheck("DirectPrint") == "No") { base.Show(); this.BringToFront(); } else { crptProductStatisticsReport.PrintToPrinter(1, false, 0, 0); } } catch (Exception ex) { MessageBox.Show("PSR" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }