private void getData()
{
RptViewer.Reset();
CommisionReceivableBo CommisionReceivableBo = new CommisionReceivableBo();
DataTable dt = CommisionReceivableBo.GetBranchBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt2 = CommisionReceivableBo.GetAssociateBrokerage(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt3 = CommisionReceivableBo.GetProductApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
DataTable dt4 = CommisionReceivableBo.GetAssocaiteApplicationWiseData(product, productCategory, fromdate, todate, amcCode, schemeId, adviserId, issueid, CommissionType);
ReportDataSource rds = new ReportDataSource("BranchDS_SPROC_GetBranchBrokerageReceivable", dt);
ReportDataSource rds2 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetAssociateWiseBrokerageReceived", dt2);
ReportDataSource rds3 = new ReportDataSource("ProductBrokerageApplicationWise_SPROC_GetProductBrokerageApplicationWise", dt3);
ReportDataSource rds4 = new ReportDataSource("ProductAssociateBrokarageReceived_SPROC_GetBranchAssociateCommissionPayOuts", dt4);
RptViewer.LocalReport.DataSources.Add(rds);
RptViewer.LocalReport.DataSources.Add(rds2);
RptViewer.LocalReport.DataSources.Add(rds3);
RptViewer.LocalReport.DataSources.Add(rds4);
RptViewer.LocalReport.ReportPath = @"Reports\BrokerageMIS.rdlc";
ReportParameter[] RP = new ReportParameter[] {
new ReportParameter("Product", product),
new ReportParameter("Category", productCategory),
new ReportParameter("FromDate", fromdate),
new ReportParameter("ToDate", todate),
new ReportParameter("AMCCode", amcCode.ToString()),
new ReportParameter("IssueId", issueid.ToString()),
new ReportParameter("IsReceivable", IsReceivable),
new ReportParameter("CommissionType", CommissionType),
new ReportParameter("Channel", "true"),
};
RptViewer.LocalReport.SetParameters(RP);
RptViewer.LocalReport.Refresh();
}