Report Timing Out when running in Infoview

[SSSFisgard]

Hey everyone,

So we've run into a problem that we can't find an answer to. Here's where we're at:

BOE XIR2. Report has been written based on stored procedures. It also contains 5 sub reports all pointing to the same stored procedure. When we run this report locally it takes our programmer 2 minutes to run. He says it runs no problem.

Now when we post this to infoview and run it there, we wait probably 2 minutes and 15 seconds and receive this message "An error has occurred: Request timed out."

Now our programmer says it IIS or a timeout setting on our SQL server, but we are unable to verify if this is really the cause.

Anybody out there have any ideas?

Thanks

SSSFisgard