Report control question for page break RRS feed

  • Question

  • I have report(report.rdlc) binding to database table and set group for page break, It works fine.

    but when I binding large data table(greater than 1 million rows) , the report show very slowly.

    I saw the sql statement in SQL Server Profiler, it is like 'select a,b,c from TestTable', so it must be slowly.

    I would implement page breaks like 'select top 20 a,b,c from TestTable' so that for each I can fetch a few of rows.

    Tuesday, February 5, 2013 5:49 AM