HunainHafeez 9 Posting Whiz

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.