Questions using RS2005

I have two questions. Both of my questions are based on my experiences
briefly using RS2000. First, has RS2005 managed to fix the problem with
returning large (average 50K) records without eating up all the server
resources or even crashing the server. This happened when I was using RS2000
regardless if I was using paging feature like returning partial records at a
time. I've called MS and the support person told me that RS2000 was not
meant to return more than 10k records. I thought that was stranged but I
kind of understand. Have this issue been resolved in RS2005? Or do I
continue using Crystal Reports..
Second question is regarding dataset being pass from asp.net. In RS2000,
there was no way to pass dataset from asp.net to RS2000. I know few people
in the past have created their own customize dataset (Teo Lachev is one) to
be able to pass datasets (not rs2000 dataset but, dataset in asp.net/
vb.net). Have RS2005 added this feature? Thanks in advance.
HenryRS 2005 has not changed how it is managing rendering. Rendering is done in
memory which is why the problem returning 50,000 records IF rendering to PDF
or Excel. Rendering this size in HTML or CSV is not a problem (in either RS
2000 or 2005). If this is your reason to stay away then you either need to
consider CSV (this many records is not for human consumption, it is a data
export and CSV works well for that).
Second, VS 2005 comes with two new controls that you can run in either local
mode or server mode. In local mode you give it a dataset. Note that in local
mode you have to do more work (handling sub reports etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:8AE7E99E-1E90-4DA7-B8BC-8AF03BE80BE7@.microsoft.com...
>I have two questions. Both of my questions are based on my experiences
> briefly using RS2000. First, has RS2005 managed to fix the problem with
> returning large (average 50K) records without eating up all the server
> resources or even crashing the server. This happened when I was using
> RS2000
> regardless if I was using paging feature like returning partial records at
> a
> time. I've called MS and the support person told me that RS2000 was not
> meant to return more than 10k records. I thought that was stranged but I
> kind of understand. Have this issue been resolved in RS2005? Or do I
> continue using Crystal Reports..
> Second question is regarding dataset being pass from asp.net. In RS2000,
> there was no way to pass dataset from asp.net to RS2000. I know few
> people
> in the past have created their own customize dataset (Teo Lachev is one)
> to
> be able to pass datasets (not rs2000 dataset but, dataset in asp.net/
> vb.net). Have RS2005 added this feature? Thanks in advance.
> Henry