sql server reporting services: If you report has paramters then you are just seeing building the report, no
parameters then it is also executing the report. Once it has executed it
though, it then caches the data (look in your directory and you will see
reportname.rdl.data). Even a pretty complicated report takes only a couple
of seconds to build the report. Ususally a second or less. How much RAM do
you have. It seems to me like you might be getting some thrashing going on.



[quoted text, click to view]
really like it. I am using Visual Studio .net for developing reports. I
have noticed a long delay when changing between the 'Layout Tab' and the
'Preview Tab'. The delay is between 10 and 15 seconds which may not seem
like much but adds up over time. Does anyone know if this is an issue with
RS or the .net environment? Are there settings to change to make this
change quicker? I know each time you change from one tab to another a new
..rdl file has to be built but I have witnessed several demos from Microsoft
and their setups appear to be instantaneous. Any ideas would be helpful!!!
Thanks, Dave
[quoted text, click to view]

That is faster than my machine but I have 512MB more RAM than you. Besides
adding RAM if you can, how do you have your data source setup, is it a
shared datasource or are you doing it per report. I use shared data source.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]
megs of ram. I consistently see this delay regardless of whether the report
has parameters or not. The delay occurs before the 'Processing Report...'
dialogue appears. The same query in query analyzer takes fractions of a
second to complete. Any additional insight would be greatly appreciated.
Thanks, Dave
[quoted text, click to view]

I don't know what else it could be. I have a slower computer and don't see
this. Do you have SQL Server and IIS locally as well? If so then SQL Server,
IIS, VS is a lot in 256 MB. Bring up task manager and see what is going on,
you should be able to see memory usage.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Hello, I have been working with Reporting Services for several months and really like it. I am using Visual Studio .net for developing reports. I have noticed a long delay when changing between the 'Layout Tab' and the 'Preview Tab'. The delay is between 10 and 15 seconds which may not seem like much but adds up over time. Does anyone know if this is an issue with RS or the .net environment? Are there settings to change to make this change quicker? I know each time you change from one tab to another a new .rdl file has to be built but I have witnessed several demos from Microsoft and their setups appear to be instantaneous. Any ideas would be helpful!!! Thanks, Dave

--

Thank you for your response. My client station is a 3Ghz Pentium with 256 megs of ram. I consistently see this delay regardless of whether the report has parameters or not. The delay occurs before the 'Processing Report...' dialogue appears. The same query in query analyzer takes fractions of a second to complete. Any additional insight would be greatly appreciated. Thanks, Dave

--

I am using a shared datasource. I wish I knew if increasing memory would solve this problem before upgrading. Thanks for your responses. Dave

--