Unanswered: SQL Server Reporting Services - Capacity/Limitation?
My new web application makes use of reporting services and generates excel reports based on data in the database
The larger reports are timing out or not executing at all (when I remove all timeout options). The smaller reports work just fine.
Does anyone have experience with running large reports and having them automatically exported to excel? In some cases I can view the report on the reporting server directly, but it will not render it in excel.
An example report is normalizing 20,000 rows, displaying approximatley 3,330 user records with 6 records of detail below each one
is this too much for it to handle? it shouldn't be!