public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SalesCR rpt = new SalesCR(); rpt.Site = this.Site; return(rpt); }
private void QueryBTN_Click(object sender, EventArgs e) { repoerts_form RForm = new repoerts_form(); SalesCR SalesRep = new SalesCR(); ParameterFields SalesParam = new ParameterFields(); ParameterField FromDate = new ParameterField(); ParameterDiscreteValue FromDatevalue = new ParameterDiscreteValue(); ParameterField ToDate = new ParameterField(); ParameterDiscreteValue ToDatevalue = new ParameterDiscreteValue(); ParameterField CatId = new ParameterField(); ParameterDiscreteValue CatIdValue = new ParameterDiscreteValue(); ParameterField RbF = new ParameterField(); ParameterDiscreteValue RbFvalue = new ParameterDiscreteValue(); ParameterField AgentId = new ParameterField(); ParameterDiscreteValue AgentIdvalue = new ParameterDiscreteValue(); ParameterField ItemId = new ParameterField(); ParameterDiscreteValue ItemIdvalue = new ParameterDiscreteValue(); ParameterField OperType = new ParameterField(); ParameterDiscreteValue OperTypevalue = new ParameterDiscreteValue(); ParameterField op_type = new ParameterField(); ParameterDiscreteValue op_dis = new ParameterDiscreteValue(); op_type.Name = "op_type"; op_type.CurrentValues.Add(op_dis); op_dis.Value = OperTypeCB.Text; { FromDate.Name = "fromDate"; FromDatevalue.Value = FromDateTB.Text; ToDate.Name = "ToDate"; ToDatevalue.Value = ToDateTB.Text; ItemId.Name = "ItemId"; RbF.Name = "RbF"; AgentId.Name = "AgentId"; CatId.Name = "CatId"; OperType.Name = "OperType"; OperTypevalue.Value = "'SEL'"; if (OperTypeCB.SelectedIndex == 1) { OperTypevalue.Value = "'REF'"; } CatIdValue.Value = 0; AgentIdvalue.Value = 0; if (CategoryCB.Text.Trim() != "") { CatIdValue.Value = CategoryCB.SelectedValue; } if (AgentQCB.Text.Trim() != "") { AgentIdvalue.Value = AgentQCB.SelectedValue; } ItemIdvalue.Value = 0; // RbFvalue.Value = 6; if (ItemIdTB.Text != "" && sel_rp_cod_rdbtn.Checked) { ItemIdvalue.Value = ItemIdTB.Text; } else if (ItemCB.Text != "" && ItemRB.Checked) { ItemIdvalue.Value = meth.select_sanf_data_by_name(ItemCB.Text.Trim()).Rows[0][0]; } if (sel_rp_cod_rdbtn.Checked == true && AgentCHB.Checked == false) { RbFvalue.Value = 0; } else if (sel_rp_cod_rdbtn.Checked == true && AgentCHB.Checked == true) { RbFvalue.Value = 1; } if (ItemRB.Checked == true && AgentCHB.Checked == false) { RbFvalue.Value = 0; } else if (ItemRB.Checked == true && AgentCHB.Checked == true) { RbFvalue.Value = 1; } else if (CatRB.Checked == true && AgentCHB.Checked == false) { RbFvalue.Value = 2; } else if (CatRB.Checked == true && AgentCHB.Checked == true) { RbFvalue.Value = 3; } else if (AllRB.Checked == true && AgentCHB.Checked == false) { RbFvalue.Value = 4; } else if (AllRB.Checked == true && AgentCHB.Checked == true) { RbFvalue.Value = 5; } AgentId.CurrentValues.Add(AgentIdvalue); FromDate.CurrentValues.Add(FromDatevalue); ToDate.CurrentValues.Add(ToDatevalue); ItemId.CurrentValues.Add(ItemIdvalue); RbF.CurrentValues.Add(RbFvalue); CatId.CurrentValues.Add(CatIdValue); OperType.CurrentValues.Add(OperTypevalue); SalesParam.Add(ToDate); SalesParam.Add(OperType); SalesParam.Add(RbF); SalesParam.Add(AgentId); SalesParam.Add(FromDate); SalesParam.Add(ItemId); SalesParam.Add(CatId); SalesParam.Add(op_type); RForm.rep_crst.ReportSource = SalesRep; RForm.rep_crst.ParameterFieldInfo = SalesParam; RForm.Show(); RForm.Dock = DockStyle.Fill; } }