Not able to fetch all data to RDLC Report

Question

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