<div>
so it successfully runs sometimes and shows this error at other times?
</div>


so it successfully runs sometimes and shows this error at other times?

<div>
Yes, I believe it is a time-out issue in Visual Studio 2008. The dataset is very large and therefore takes several minutes to load the report. I reduce the parameter range, reducing the dataset size the report runs fine.<br />
<br />
There is no problem running the report in production once it has been uploaded to the report server.<br />
<br />
I think I will have to put this down to another Microsoft bug...
</div>


Yes, I believe it is a time-out issue in Visual Studio 2008. The dataset is very large and therefore takes several minutes to load the report. I reduce the parameter range, reducing the dataset size the report runs fine.

There is no problem running the report in production once it has been uploaded to the report server.

I think I will have to put this down to another Microsoft bug...

<div>
Hi,<br />
<br />
Thanks for your recommendations, I would like to do this but I just haven't got the time to do this.... The report is a KPI dashboard report that compares year on year data, so the dataset is always going to be very large. The report is Snapshot every 12 hours so the users do not notice the slowness of the running of the report.<br />
<br />
Thanks, Greg
</div>


Hi,

Thanks for your recommendations, I would like to do this but I just haven't got the time to do this.... The report is a KPI dashboard report that compares year on year data, so the dataset is always going to be very large. The report is Snapshot every 12 hours so the users do not notice the slowness of the running of the report.

Thanks, Greg

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have created a dashboard report that connects to several different database connections. The report takes several minutes to run due to the amount of data that is being queried.<br />
<br />
I have just tired to preview the report and I am getting the following error:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/09_w36/870846/Capture.JPG" target="_blank" title="SSRS Preview Error (14 KB)"><img alt="SSRS Preview Error" class="file-block lazyload" style="max-width: 763px;" data-src="https://filedb.experts-exchange.com/incoming/2014/09_w36/870846/Capture.JPG" /></a><br />
Please could someone help? Is this a time-out issue?
</div>
</div>


Capture.JPG

Hi,

I have created a dashboard report that connects to several different database connections. The report takes several minutes to run due to the amount of data that is being queried.

I have just tired to preview the report and I am getting the following error:



Please could someone help? Is this a time-out issue?

SSRS Report Preview Problem

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.