data load to Rdlc Report

Question

hi sir how to load table records faster in to rdlc report. i have 280000 records in my table. i dont know how to fix this issue  would you help me sir.....

Nitin Sontakke · Answer

You will need to concentrate on execution of the sql or stored procedure. What is it a single select query or a stored procedure? Are there indexes on tables involved? You will need to examine the execution plan. This has nothing to do with rdlc just keep improving performance in Query Analyzer first.