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

Report Server 2005 - How to SUM value by condition

hi, i need some help on this.

I create Matrix that show the sales and cancels of the sales department.

The TOTAL in the Matrix are fine, but i need to show also how many Sales

(param is bigger then 0) and how many cancels (param is negative, smaller the 0) each

sales man have in the Matrix report. i try to use IIF statement but it only return absolute number:
--
="Sales :" & (IIF(Fields!SalesCommission.Value<0, sum(Fields!SalesCommission.Value), 0)) &
"Cancels :" & (IIF(Fields!SalesCommission.Value>0, sum(Fields!SalesCommission.Value), 0)) &
"Total :" & IIF(sum(Fields!SalesCommission.Value)<0, "(" & Format(ABS(sum(Fields!SalesCommission.Value)),"F1") & ")" ,sum(Fields!SalesCommission.Value))
--

I think i will need to use Costum Code on this one.

anny advice ?

Thanks

It looks like your IF statements are backwards from what you want. Your output for your "Sales:" will return sum(Fields!SalesCommission.Value) when Fields!SalesCommission.Value is less then 0. Your output for your "Cancels:" will return sum(Fields!SalesCommission.Value) when Fields!SalesCommission.Value is greater then 0. This is because IIF( [EXPRESSION], [TRUE PART], [FALSE PART]). So it should look like:

="Sales :" & (IIF(Fields!SalesCommission.Value>0, sum(Fields!SalesCommission.Value), 0)) &
"Cancels :" & (IIF(Fields!SalesCommission.Value<0, sum(Fields!SalesCommission.Value), 0)) &

See what that does for you. Maybe I misunderstood/misread what you wanted for that part. Try and see what that does for you.

|||

Thanks, you are right, i replace the Sales and Cancels places.

I try your sample but again, the Matrix row have both Sales and Cancels in the Matrix TOTAL boxes and the EXPRESSION return the Total of the Sales O.K but the Total of the Cancels is 0 (zero).

What i need is to show in the MATRIX table the totals per salesman (Sales - (Minus) Cancels) and the clculatet Braek of

For exsaple:

Salse: 12.5

Cancels: -6.5

Total: 6

Anny Advice ?

|||So a "Cancels" is commision under 0 dollars. And a "Sales" is commission over 0 dollars. So you want to find how much commission total each sales person made? If I understand you correctly, all you need to do is sum(Fields!SalesCommission.Value) for your total. That should take care of everything. I hope this helps!

Report Server 2005 - How to SUM value by condition

hi, i need some help on this.

I create Matrix that show the sales and cancels of the sales department.

The TOTAL in the Matrix are fine, but i need to show also how many Sales

(param is bigger then 0) and how many cancels (param is negative, smaller the 0) each

sales man have in the Matrix report. i try to use IIF statement but it only return absolute number:
--
="Sales :" & (IIF(Fields!SalesCommission.Value<0, sum(Fields!SalesCommission.Value), 0)) &
"Cancels :" & (IIF(Fields!SalesCommission.Value>0, sum(Fields!SalesCommission.Value), 0)) &
"Total :" & IIF(sum(Fields!SalesCommission.Value)<0, "(" & Format(ABS(sum(Fields!SalesCommission.Value)),"F1") & ")" ,sum(Fields!SalesCommission.Value))
--

I think i will need to use Costum Code on this one.

anny advice ?

Thanks

It looks like your IF statements are backwards from what you want. Your output for your "Sales:" will return sum(Fields!SalesCommission.Value) when Fields!SalesCommission.Value is less then 0. Your output for your "Cancels:" will return sum(Fields!SalesCommission.Value) when Fields!SalesCommission.Value is greater then 0. This is because IIF( [EXPRESSION], [TRUE PART], [FALSE PART]). So it should look like:

="Sales :" & (IIF(Fields!SalesCommission.Value>0, sum(Fields!SalesCommission.Value), 0)) &
"Cancels :" & (IIF(Fields!SalesCommission.Value<0, sum(Fields!SalesCommission.Value), 0)) &

See what that does for you. Maybe I misunderstood/misread what you wanted for that part. Try and see what that does for you.

|||

Thanks, you are right, i replace the Sales and Cancels places.

I try your sample but again, the Matrix row have both Sales and Cancels in the Matrix TOTAL boxes and the EXPRESSION return the Total of the Sales O.K but the Total of the Cancels is 0 (zero).

What i need is to show in the MATRIX table the totals per salesman (Sales - (Minus) Cancels) and the clculatet Braek of

For exsaple:

Salse: 12.5

Cancels: -6.5

Total: 6

Anny Advice ?

|||So a "Cancels" is commision under 0 dollars. And a "Sales" is commission over 0 dollars. So you want to find how much commission total each sales person made? If I understand you correctly, all you need to do is sum(Fields!SalesCommission.Value) for your total. That should take care of everything. I hope this helps!