I am trying to generate a report in BIDS. The report is generated from SQL Server 2012 through a Stored Procedure. We are in the process of defining Indexes for the table used to generated the report. There are thousands of records in the table.
The report is getting generated after 2 mins in BIDS. The report has 3 pages. I am getting an error while trying to navigate to the second page. Has anybody come across this error. Is this error due to some timeout issue. I am attaching the screenshot.
I executed the Stored Procedure in SSMS and it is executing successfully in 2 mins. I cannot find the reason for this issue. Any help would be appreciated.