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,
Did you check whether any of the remaining columns is an non-aggregate causing the repetition?
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.
If it is list you can set group span property to avoid repeated data.