Revers running Value

Question

Hello Together,

I have a problem with a matrix in reporting services.

A part of the report should be shown in this way

1.207.652
3.386.227	2.178.575
4.665.096	1.278.869
5.877.298	1.212.202
8.156.765	2.279.467
10.388.556	2.231.791
12.674.522	2.285.966

for better understanding: 3.386.227 - 1.207.652=2.178.575, etc

My problem is to get the numbers in the white column group.

I tried with running value but I did not got it.

Thanks JO_MO

Answer 1

Hi,

Try this

Step 1: 

Create a dataset

SELECT CAST('1207.652' AS NUMERIC(18,3)) A, '0.000' B 
UNION ALL
SELECT CAST('3386.227'  AS NUMERIC(18,3)) A, '2178.575' B 
UNION ALL
SELECT CAST('4665.096'  AS NUMERIC(18,3)) A, '1278.869' B 
UNION ALL
SELECT CAST('5877.298'  AS NUMERIC(18,3)) A, '1212.202' B 
UNION ALL
SELECT CAST('8156.765'  AS NUMERIC(18,3)) A, '2279.467' B 
UNION ALL
SELECT CAST('10388.556'  AS NUMERIC(18,3)) A, '2231.791' B 
UNION ALL
SELECT CAST( '12674.522'  AS DECIMAL(18,3)) A, '2285.966' B 

Step 2:

Assign created dataset to Tablix

Step 3:
Enter "=Fields!A.Value-Previous(Fields!A.Value)" in the Tablix Textbox expression

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 2

Hi Thanks a lot that works.

Answer 3

Hi JO_MO,

Here is more information about the Previous() function. In Reporting Services, the Previous() function returns the value of the expression for the previous row of data. Its syntax is as follows:

Previous(expression, scope)

The Previous function returns the previous value for the expression evaluated in the specified scope after all sorting and filtering have been applied. If expression contains an aggregate function that uses a default scope, Previous aggregates the data within the previous instance of the scope specified in the aggregate function call. If expression contains an aggregate function that specifies a scope other than the default, the scope parameter for the Previous function must be a containing scope for the scope specified in the aggregate function call.

Reference:
http://msdn.microsoft.com/en-us/library/ms156372(v=sql.100).aspx

Regards,

---

Mike Yin
TechNet Community Support

Answer 4

Hi Mike,

thanks a lot, that was very helpful.

Regards