I have an rdlc report which is loading data from database table via Datatable but problem is that it only shows 27 records, not more. Even the sql table and datatable in c# has populated data but not getting populated in RDLC report.
I have used same code and same problem everywhere.
protected void Page_Load(object sender, EventArgs e)
{
//ASP.controls_resultlabel_ascx ResultLabel = new ASP.controls_resultlabel_ascx();
if (!IsPostBack)
{
Fill_AuditsReport();
}
}
public void Fill_AuditsReport()
{
ReportViewer1.AsyncRendering = false;
ReportViewer1.SizeToReportContent = true;
ReportViewer1.ZoomMode = ZoomMode.FullPage;
this.ReportViewer1.Reset();
DataTable dt = new DataTable();
Audits.ManageAudits MngAudits = new Audits.ManageAudits();
dt = MngAudits.SelectAuditsInfo();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/DataManagementReports/AuditsReport.rdlc");
ReportDataSource rpds = new ReportDataSource("DataSetAudits", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rpds);
ReportViewer1.Visible = true;
}
Even datatable is getting populated with full data while debugging.