> 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]" 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
> >
> >
> >
> >
>