Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2010-04-07 : 10:51:18
|
| I have 2 tables (very simplified):TableA (about 100 rows)AppID (PK)AppNameTableB (about 3,000,000 rows)ProductIDWorkstationNameMore detail, etc.....I have created a report that has a parameter for AppName and when I enter it, it brings me back a few hundred or thousand records. If I leave it blank, to run the whole report, I get an out of memory exception. I also did a similar one which had a drill down that displayed all 100 apps. Worked fine. It had the little + sign for the drill down (to detail from the appname). As soon as I clicked the + sign, it would churn for a while and then give me the out of memory error again.Evidently, it can't store a large dataset in memory. I don't understand the inner workings of SSRS, so I was wondering - how can I work around this?Duane |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-07 : 11:32:02
|
| Just guessing here, perhaps you can set up the report to be produced as a subscription when you do a "full" run, and have it rendered in say a PDF format for example.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
Out of memory error