Click here to Skip to main content
14,981,456 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have an expression like this

Doc_No      Category    Material    Rev0    Rev1    Rev2...  Total 
1          A              xxx        2      3       0        2+3+0=5 
                          yyy        0     20       0        0+20+0=20 
           G              xxx       -1      1       0       -1+1+0=0 
                          yyy       10     12      23       10+12+23 =45

Here i want to display one more column for total values ...

for this i'm using RunningValues, but In that i want to Concatenate Doc_no, Category,Material..


here Doc_No is column value , based upon doc_no total quantity is displayed upto now.
But i want to bind the scope values more than 1 , how to do ...


now the scope value is ---- "Doc_No"

but i want to bind more than one value
like ---- "Doc_No + Category...."

How to achieve this...

Any one help me regarding this issue...
Updated 20-Feb-13 18:54pm

1 solution


Check the Following Link

Cumulative Aggregates in SQL Server Reporting Services[^]


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900