Groups | Blog | Home
all groups > sql server reporting services > october 2005 >

sql server reporting services : disable automatic execution and rendering



ZWeng
10/21/2005 2:20:04 PM
I use asp.net page to view the reports. Some of my reports take parameters
and I set them default to '%' as while cards.

When a report link is clicked, the report is executed and rendered when the
new page is open. Some of them returns really quite some records so it takes
a while to have the page rendered.

Is there a setting somewhere that the reports are not executed and rendered
when the hosting page is open and the process will start only when the "View
Report" button is clicked?

Thank you.

Bruce L-C [MVP]
10/21/2005 4:42:10 PM
You need at least one parameter to not have a default. Otherwise it renders
automatically. I would prefer this behaviour to be different. I haven't
checked 2005 to see if it has changed but this is the way it works in 2000.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Wayne Snyder
10/24/2005 4:15:02 AM
It still works the same way in RS 2005... It would be nice to have a
No-Autorender flag...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]
AddThis Social Bookmark Button