public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PettyCashVoucherReport rpt = new PettyCashVoucherReport();
rpt.Site = this.Site;
return(rpt);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PettyCashVoucherReport rpt = new PettyCashVoucherReport();
rpt.Site = this.Site;
return rpt;
}
/* private void loadGrid()
{
core_petty_cash_payment_voucher pcvObj = new core_petty_cash_payment_voucher();
DataSet ds = pcvObj.SelectMethod(@"SELECT
pcv.Id_Petty_Cash_Voucher,
pcv.Id_Petty_Cash_Book,
pcb.Petty_Cash_Book_Name,
pcb.Petty_Cash_Book_Code,
pcb.Available_Balance_Amount,
pcv.Id_Petty_Cash_Category,
pcc.Petty_Cash_Category_Name,
pcc.Petty_Cash_Category_Code,
pcv.Cash_Out_Amount,
pcv.Business_Purpose,
pcv.Received_By,
pcv.Petty_Cash_Voucher_Remark,
pcv.Post_Payment,
CASE WHEN pcv.Post_Payment=0 THEN 'Post-payment' ELSE 'Pre-payment' END AS Payment_Type,
pcv.Created_Date,
pcv.Created_User,
pcv.Edited_Date,
pcv.Edited_User
FROM core_petty_cash_payment_voucher AS pcv
INNER JOIN core_petty_cash_book AS pcb ON pcv.Id_Petty_Cash_Book=pcb.Id_Petty_Cash_Book
INNER JOIN core_petty_cash_category AS pcc ON pcv.Id_Petty_Cash_Category=pcc.Id_Petty_Cash_Category
WHERE pcv.Is_Active='0';", "core_petty_cash_payment_voucher");
if (ds.Tables["core_petty_cash_payment_voucher"] != null)
{
GridView1.DataSource = ds.Tables["core_petty_cash_payment_voucher"];
GridView1.DataBind();
}
else
{
GridView1.DataSource = new int[] { };
GridView1.DataBind();
}
} */
private void getReport()
{
PettyCashVoucherReport irpt = new PettyCashVoucherReport();
if (IsPostBack)
{
TextObject pcvID = (TextObject)irpt.ReportDefinition.Sections["Section1"].ReportObjects["Text3"];
TextObject cashoutamount = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text21"];
TextObject receivedby = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text22"];
TextObject paymentType = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text23"];
TextObject businesssPurpose = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text24"];
TextObject pcbName = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text25"];
TextObject pcbCode = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text26"];
TextObject pccName = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text27"];
TextObject pccCode = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text28"];
TextObject remark = (TextObject)irpt.ReportDefinition.Sections["Section3"].ReportObjects["Text29"];
pcbName.Text = ddlPCBName.SelectedItem.Text;
pcbCode.Text = ddlPCBCode.SelectedItem.Text;
pccName.Text = ddlPCCName.SelectedItem.Text;
pccCode.Text = ddlPCCCode.SelectedItem.Text;
remark.Text = PCV_Remark.Text;
pcvID.Text = PCV_Id.Text;
cashoutamount.Text = cashOutAmount.Text;
receivedby.Text = receivedBy.Text;
paymentType.Text = RadioButtonList1.SelectedValue.ToString();
businesssPurpose.Text = businessPurpose.Text;
}
// crvPettyCashVoucherReport.ReportSource = null;
crvPettyCashVoucherReport.EnableDatabaseLogonPrompt = false;
Session["ReportDocument"] = irpt;
ReportDocument doc = (ReportDocument)Session["ReportDocument"];
if (doc != null)
crvPettyCashVoucherReport.ReportSource = doc;
crvPettyCashVoucherReport.DataBind();
}