To Remove Repeated data after Grouping

[sg24]

Hi Folks,

I have Control , Issues and Tests col along with the other columns in the report.

Issues and tests are related to Control col. I have grouped these columns.

Now for each of the tests that are associted to a control Issues repeat. Meaning for different tests Issues are repeating. Can this be avoided anyway?

Please let me know if i need to be more clear on this?

Kindly respond.

Thanks,

[blom0344]

Did you check whether any of the remaining columns is an non-aggregate causing the repetition?

[MFGF]

Hi,

I'm not quite clear on the order of things here. Are you saying an Issue can have many tests? Or a Test can have many issues? Or both??

I imagine the order in which you group these will have a bearing on where the repetitions appear (or don't appear) although as is usual for me, I'm a little confused over exactly how your data works here :-)

Regards,

MF.

[HalfBloodPrince]

If it is list you can set group span property to avoid repeated data.