Hi

Perhaps nOt really a direct answer to your question, but you can download here a sql dashboard for reporting services so you can monitor.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Which processors are you using ?...

Mike

I'm using the RS2005 and SQL2005 and using stored procedures.

But I don't get it right. Could give more details how to deal with it ?

Thx in advance (C my other...

Hi

Could you give some details of yr table data so i can understand that tricky part ?

thx

Hey guyz

I solved the problem.

Strange enough when i tear down the calculation it works just fine.

Many thx for helping me solving this.

Hi aren't u using reporting services ?

First of all, thnx for looking into this.

The purpose of this sp is to calculate a code depending on a cardnbr and date of today.

The formula is ok in the...

Using just the data or the stored procedure ?

Hi

the green is the calculation method.

in my next reply the <-------------- are the results of this stored procedure

and they should be (20 + 218) , (3 * (0 +...

Hi, sorry : it's 200031250

Here are the results when running the stored procedure :

Reset status

99

---------

Status voor select statement

12

-------

Calculation

20218 <---------------

654 <----------------

218526 <------------------

327834 <---------------------

Kaartnummer : 200031250

------------------------

Results :

Status : 0

Dag :...

Well no, because we have used the subtotal function.

So we should not use the subtotal function but create are own subtotal ?

Kind regards

Dan

Do you use stored procedures or do u use t-sql within yr dataset ?

In both u can mention on top set dateformat.

It solved a date issue of mine.

If u use...

Hi Phill

Where exactly should you change this ?

Thx in advance