Sandeep Kumar

Sandeep Kumar

  • 509
  • 4.3k
  • 800.4k

Not able to fetch all data to RDLC Report

Oct 9 2017 3:28 AM
Hi All,
 
I have written one stored procedure to fetch records from more than 4 tables by using joins to display as RDLC report.But While I am selecting all Company and all Employee ,not able to get all the records cause of hudge data in database or connection lost between front and back end .(But while I am selecting 1 or 2 company name then data is coming fine only).
 
Note:SqlCommand.TimeOut is not recommended because of burden in DB.So has any one idea or suggestion to resolve this issue.
 
Thanks & Regards,
Sandeep 

Answers (1)