public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crptPricelistDynamic rpt = new crptPricelistDynamic();
rpt.Site = this.Site;
return(rpt);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
crptPricelistDynamic rpt = new crptPricelistDynamic();
rpt.Site = this.Site;
return rpt;
}
/// <summary>
/// Function to print PriceListReport in curresponding Crystal report
/// </summary>
/// <param name="dsPriceListReport"></param>
internal void PriceListReportPrinting(DataSet dsPriceListReport)
{
try
{
crptPricelistDynamic crptDynamic = new crptPricelistDynamic();
DataTable dtblnew = new DataTable();
foreach (DataTable dtbl in dsPriceListReport.Tables)
{
if (dtbl.TableName == "Table1")
{
crptDynamic.Database.Tables["dtblCompanyReport"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table2")
{
crptDynamic.Database.Tables["dtblPriceListGridFill"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table3")
{
dtblnew = dtbl;
crptDynamic.Database.Tables["dtblOptions"].SetDataSource(dtbl);
}
}
LineObject line11 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line11"]);
LineObject line12 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line12"]);
LineObject line14 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line14"]);
foreach (DataRow dR in dtblnew.Rows)
{
LineObject line01;
int i = 1, j = 6;
if (dR["PurchaseRate"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "Purchase Rate");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
if (dR["SalesRate"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "Sales Rate");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
if (dR["LastSalesRate"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "Last Sales Rate");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
if (dR["StandardRate"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "Standard Rate");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
if (dR["MRP"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "MRP");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
if (dR["Price"].ToString() == "True")
{
crptDynamic.SetParameterValue("field" + i, "Price");
i++;
}
else
{
crptDynamic.SetParameterValue("field" + j, "None");
line01 = ((LineObject)crptDynamic.ReportDefinition.ReportObjects["Line0" + j]);
line01.ObjectFormat.EnableSuppress = true;
line11.Right = int.Parse(line11.Right.ToString()) - 1790;
line12.Right = int.Parse(line12.Right.ToString()) - 1790;
line14.Right = int.Parse(line14.Right.ToString()) - 1790;
j--;
}
}
this.crptViewer.ReportSource = crptDynamic;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("DirectPrint") == "No")
{
base.Show();
this.BringToFront();
}
else
{
crptDynamic.PrintToPrinter(1, false, 0, 0);
}
}
catch (Exception ex)
{
MessageBox.Show(" " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}