sort data

[sulaiman]

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

[lynn21fr]

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

[sulaiman]

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

[MFGF]

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.