report service's cache problem

hi,
i query the result in Web
my report service has only one parameter
(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
, and query it, It's Ok!
(2) Add some new record in SQL server
(3) and set the query as step(1) :
http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
newest added record could't be shown in setp (2)
To find what's the reason of this:
(1) i open the SQL Server's event-detector, and find in step 2 , Server's
event-detector cann't dectect the step(2)'s action.
(2) another test , i set the query as
http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
(3) finally, i reset the query as
http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
How puzzled it is!
I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
configution , i can shield the cache.
My opion is that in every query , the SQL Sever can dectect the action , and
reQeury the newest result.
Any sugguestion ? thanks a lot!
RainbowIn Report Manager, view the report using an admin account.
Select the Properties tab.
Then select the Execution page.
Is the radio button for Do not cache temporary copies of this report
selected?
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 00:31:09 +0800, "Rainbow" <RainbowHu@.msn.com>
wrote:
>hi,
>i query the result in Web
>my report service has only one parameter
>(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
>, and query it, It's Ok!
>(2) Add some new record in SQL server
>(3) and set the query as step(1) :
>http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
>newest added record could't be shown in setp (2)
>
> To find what's the reason of this:
>(1) i open the SQL Server's event-detector, and find in step 2 , Server's
>event-detector cann't dectect the step(2)'s action.
>(2) another test , i set the query as
>http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
>(3) finally, i reset the query as
>http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
>How puzzled it is!
>I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
>configution , i can shield the cache.
>My opion is that in every query , the SQL Sever can dectect the action , and
>reQeury the newest result.
>Any sugguestion ? thanks a lot!
>Rainbow
>
>|||-- Original Message --
From: "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Sunday, October 09, 2005 9:43 PM
Subject: Re: report service's cache problem
> In Report Manager, view the report using an admin account.
> Select the Properties tab.
> Then select the Execution page.
> Is the radio button for Do not cache temporary copies of this report
> selected?
>
thanks, Andrew
Yes, the default value in Execution page is "Do not cache temporary copies
of this report"?In My Report Manager , this is Selected.|||I have the same caching issue. It seems the Reporting Services still cache
the data even the "Do not cache temporary copies of this report" is checked.
Is this a feature or a bug?
Thank you.
"Andrew Watt [MVP - InfoPath]" wrote:
> In Report Manager, view the report using an admin account.
> Select the Properties tab.
> Then select the Execution page.
> Is the radio button for Do not cache temporary copies of this report
> selected?
> Andrew Watt
> MVP - InfoPath
> On Sun, 9 Oct 2005 00:31:09 +0800, "Rainbow" <RainbowHu@.msn.com>
> wrote:
> >hi,
> >
> >i query the result in Web
> >
> >my report service has only one parameter
> >
> >(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
> >, and query it, It's Ok!
> >(2) Add some new record in SQL server
> >(3) and set the query as step(1) :
> >http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
> >newest added record could't be shown in setp (2)
> >
> >
> > To find what's the reason of this:
> >(1) i open the SQL Server's event-detector, and find in step 2 , Server's
> >event-detector cann't dectect the step(2)'s action.
> >(2) another test , i set the query as
> >http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
> >(3) finally, i reset the query as
> >http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
> >
> >How puzzled it is!
> >I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
> >configution , i can shield the cache.
> >My opion is that in every query , the SQL Sever can dectect the action , and
> >reQeury the newest result.
> >
> >Any sugguestion ? thanks a lot!
> >
> >Rainbow
> >
> >
> >
> >
>