sql server reporting services: Hi-

When I use Visual Studio and the Preview method of viewing a report,
any DrillDowns or Toggles operate quickly and nicely.

However, when I deploy to the server and access the report via IE, the
report behaves slowly, twitchy, and just oddly. It wants to
reposition the data to put my toggled item at the top of the page -
and in doing so looks like cr@p and takes a second or 3 to do so.

Anyone else see this behavior and if so, find a way to get around it.

Note: I am NOT talking about the "FixedHeader" property of a "Table".
I'm talking about toggled data in a table and the header is not fixed
- which is the default.

Thanks in advance for any ideas - B

[quoted text, click to view]


The majority of the sluggishness and rendering is due to the fact that
Visual Studio does not require interfacing w/IIS when in preview mode
whereas when the report is deployed it has to interface w//the web
server/IIS. Part of the rendering issue is that the report is having
to do a postback to the web server during the drill-down process when
deployed (like a standard web application/site). This is not the case
in VS. To improve performance, I would recommend using only stored
procedures in the report for datasets and parameters. Also, I would
suggest using the Database Engine Tuning Advisor against the query/
stored procedure that is sourcing the report to improve performance.
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

Thanks E-

The DB itself is tight and performs fine.

Any suggestions on improving the Postback/IIS performance ?
I do have debug turned off but boy - it is HORRIBLY glitchy - I cannot
believe anyone at MS finds it acceptable.

They need to use AJAX in the next version and abandon this Postback
cr@p.

Again, any IIS performance hints are more than welcome.

- B