protected void printAllFundButton_Click(object sender, EventArgs e)
{
DataTable dtFundInfoDetails = reportObj.dtFundInfoDetails(" ");
DataTable dtPriceDetails = dtPriceDetails = reportObj.dtPriceDetails(" AND FUND_CD='" + dtFundInfoDetails.Rows[0]["FUND_CD"].ToString().ToUpper() + "' AND REFIX_DT=(SELECT MAX (REFIX_DT) FROM PRICE_REFIX WHERE FUND_CD='" + dtFundInfoDetails.Rows[0]["FUND_CD"].ToString().ToUpper() + "') ");
for (int looper = 1; looper < dtFundInfoDetails.Rows.Count; looper++)
{
DataTable dtprice = reportObj.dtPriceDetails(" AND FUND_CD='" + dtFundInfoDetails.Rows[looper]["FUND_CD"].ToString().ToUpper() + "' AND REFIX_DT=(SELECT MAX (REFIX_DT) FROM PRICE_REFIX WHERE FUND_CD='" + dtFundInfoDetails.Rows[looper]["FUND_CD"].ToString().ToUpper() + "') ");
dtPriceDetails.Merge(dtprice);
}
dtPriceDetails.TableName = "dtPriceInfo";
CR_PriceRefixation.Refresh();
CR_PriceRefixation.SetDataSource(dtPriceDetails);
CR_PriceRefixation.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "AllFundLastPrice" + DateTime.Now + ".pdf");
}
