private void ShowReport(string ID)
{
try
{
ReportViewer1.LocalReport.DataSources.Clear();
DSEstateManagement ds = new DSEstateManagement();
string reportPath = Server.MapPath("EstatePlotInstallmentsPaymentRpt.rdlc");
DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter();
DSEstateManagementTableAdapters.usp_EstatePlotInstallmentsPaymentRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotInstallmentsPaymentRptTableAdapter();
da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID));
da2.Fill(ds.usp_EstatePlotInstallmentsPaymentRpt, Convert.ToInt32(ID));
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = reportPath;
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"]));
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotInstallmentsPaymentRpt"]));
ReportViewer1.LocalReport.Refresh();
}
catch (Exception e)
{
}
}
private void ShowReport(string ID)
{
try
{
ReportViewer1.LocalReport.DataSources.Clear();
DSEstateManagement ds = new DSEstateManagement();
string reportPath = Server.MapPath("PlotPreviousHistoryRpt.rdlc");
DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter();
DSEstateManagementTableAdapters.usp_EstatePlotPreviousHistoryIndustryInfoRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotPreviousHistoryIndustryInfoRptTableAdapter();
da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID));
da2.Fill(ds.usp_EstatePlotPreviousHistoryIndustryInfoRpt, Convert.ToInt32(ID));
ReportParameter paramLogo = new ReportParameter();
paramLogo.Name = "PicPath";
paramLogo.Values.Add(ServerPath);
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = reportPath;
ReportViewer1.LocalReport.SetParameters(paramLogo);
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"]));
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotPreviousHistoryIndustryInfoRpt"]));
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(OwnerDetailReportHandler);
ReportViewer1.LocalReport.Refresh();
}
catch (Exception e)
{
}
}
private void ShowReport(string ID)
{
try
{
ReportViewer1.LocalReport.DataSources.Clear();
DSEstateManagement ds = new DSEstateManagement();
string reportPath = Server.MapPath("StatusDevelopmentChargesRpt.rdlc");
DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter();
DSEstateManagementTableAdapters.usp_EstatePlotChargesRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotChargesRptTableAdapter();
da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID));
da2.Fill(ds.usp_EstatePlotChargesRpt, Convert.ToInt32(ID), Convert.ToDateTime(txtFromDate.Text.Trim()), Convert.ToDateTime(txtToDate.Text.Trim()));
ReportParameter BetweenDates = new ReportParameter();
BetweenDates.Name = "BetweenDates";
BetweenDates.Values.Add("From : " + txtFromDate.Text.Trim() + " To : " + txtToDate.Text.Trim());
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.ReportPath = reportPath;
ReportViewer1.LocalReport.SetParameters(BetweenDates);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"]));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotChargesRpt"]));
ReportViewer1.LocalReport.Refresh();
}
catch (Exception)
{
}
finally
{
}
}