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

=RunningValue(Fields!Material_Quantity.Value,sum,"Doc_No")


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

Ex:

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...
Posted
Updated 20-Feb-13 18:54pm
v3

1 solution

Hi

Check the Following Link

Cumulative Aggregates in SQL Server Reporting Services[^]

Regards,
GVPrabu
   

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