Fast in Data Tab, Slooooooooooooooooooooow in Preview

[Patrick A]

All,

I have a report that uses a stored procedure and 7 parameters.

The stored procedure returns data in less than a second in SSMS.

The data set comes back in less than a second in the Data tab of VS
2005.

The report takes more than a minute to render in the Preview tab of VS
2005.

Any suggestions as to what I'm doing wrong / what I should investigate
to get the render time down?

Thanks,

Patrick

[SQL Superfast]

how many records are there in your resultset?

www.sqlsuperfast.com



Submitted via EggHeadCafe
C# Dynamic XElement wrapper
http://www.eggheadcafe.com/tutorials/aspnet/b830e703-480e-4dde-a957-bda9b6fc8d47/c-dynamic-xelement-wrapper.aspx

[Patrick A]

Less than 100.

Post by SQL Superfast
how many records are there in your resultset?
www.sqlsuperfast.com
Submitted via EggHeadCafe
C# Dynamic XElement wrapperhttp://www.eggheadcafe.com/tutorials/aspnet/b830e703-480e-4dde-a957-b...