June 1, 2007 at 8:20 am
Hello all,
I have a question about Reporting Services 2005 + Reporting Services 2005 Control in conjunction with a Website. My main concern is the size of the dataset and where it's stored and when is it transmitted to the client's end.
It's rather easy to make a query return a generally large dataset, then by the reporting Groups, hide the data and only show it when the client expands it. Is this data set sent to the client's end all at once from the beginning and then the interaction of group collapsing, etc is just done on the client's end. Or is the dataset in its entirety stored on the Server's end (RAM, etc.) then only the data is sent to the client that is displayed from Group collapsing\expanding etc.
I'd like to harness the power of dynamic expanding\collapsing of Groups, Interactive Sorting, etc. But if the dataset in it's full has to be sent to each client, instead of chunks of only visible portions or something, then I will have to skip these features for now.
Hopefully, someone can shed a little light on the inner workings of this for me.
Thanks in Advance,
Brandon Russell
June 1, 2007 at 9:57 am
That is very good question last week a coworker run into the problem Asp.net runtime puts a 4meg limit by default to a report but you can change the max length property in Machine.Config, one step above web.config. I have not done it personally so check the Asp.net Docs for more info. Hope this helps.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply