saratoga
Unpaid Help
I created a report in SSRS for the finance people this week from one of our cubes so they can use it for their 3rd quarter planning because they were scratching their heads trying to pivot that much data.
This is no lie... the damn report renders out to 123 columns wide and who knows how many rows. Depending on the parameters they choose, the excel file it exports can be up to 5 GB.
My place uses Microsoft products for it's enterprise BI, and the finance dept has SSMS and SSRS running on a box with 4 GB of RAM. SSMS reserves nearly 75% of that leaving just a shade over 1 GB for the report server. I tested the report on our development box with no issues, put it on their server and ka-boom.
It was a long day.
This is no lie... the damn report renders out to 123 columns wide and who knows how many rows. Depending on the parameters they choose, the excel file it exports can be up to 5 GB.
My place uses Microsoft products for it's enterprise BI, and the finance dept has SSMS and SSRS running on a box with 4 GB of RAM. SSMS reserves nearly 75% of that leaving just a shade over 1 GB for the report server. I tested the report on our development box with no issues, put it on their server and ka-boom.
It was a long day.
