lisayan
asked on
sum() in group in sql reporting services
I create two group in a report, for example in group1(ID) 110116, the data
items are like the following:
110116 (group1)
TC0012
1
1 (1)
TC0011
1.5
1.5 (1.5)
TC0010
1.5
1.5 (1.2)
I need a sum 1 + 1.5 + 1.5 = 4 , but I always get 8 when I use sum(fields,
scope) in reporting services.
Is there any way to implement it ? Appreciate for any comments and
suggestions.
Lisa
items are like the following:
110116 (group1)
TC0012
1
1 (1)
TC0011
1.5
1.5 (1.5)
TC0010
1.5
1.5 (1.2)
I need a sum 1 + 1.5 + 1.5 = 4 , but I always get 8 when I use sum(fields,
scope) in reporting services.
Is there any way to implement it ? Appreciate for any comments and
suggestions.
Lisa
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have resolved my problem. Although the method is not the same as yours, I still give points to you two. My solution is:
1. use select sum(column) as counter from .... get counter number for each row.
2. use sum(fields!column_value/fi
Lisa