disable automatic execution and rendering

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.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
"ZWeng" <ZWeng@.discussions.microsoft.com> wrote in message
news:32F0A618-C751-479F-9FE1-7CF542E71A35@.microsoft.com...
>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.
>|||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.
"Bruce L-C [MVP]" wrote:
> 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
> "ZWeng" <ZWeng@.discussions.microsoft.com> wrote in message
> news:32F0A618-C751-479F-9FE1-7CF542E71A35@.microsoft.com...
> >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.
> >
> >
>
>