im working on a list report in report studio.. something like this..
name item1(label) item2(label) item3(label) item 4 (label) total.
(name) (item1value) (item2value) (item3value) (item4 value) row total
it does total the row and display wverything,, but the name appears 4 times.. i want it to appear just once
name 975 0 0 0 0 975
name 0 25 0 0 0 25
name 0 0 1,975 0 0 1,975
name 0 0 0 425 0 425
name 0 0 0 0 450 450
this is just for one guy.. it should not show zeros.
thanks in advance,,
M. Sulaiman
Hi,
One solution consists of putting in the property "aggregation function" of each one of the items (item1, item2, item3..) "aggregate", "maximum" or "minimum"
Hope it helps.
Lynn
already tried to do that.. it doesnt work... all the items shpuld show on the same line and total in the last column. for each person.. sorting doesnt work,, aggregation doesnt work..
anywayz thanks for helping, and please let me know if u have any other solution
Thanks
M. Sulaiman
Hi,
Obvious point (please don't be offended!), have you checked in the properties of the query to see that the 'Auto Group and Summarize' property is set to 'Yes'?
Secondly, in your package, are Item1, Item2, Item3 and Item4 all defined with a usage of Fact? (ie do they appear as measures in the package view?)
Regards,
MF.