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!