Hi, I've got a report which has several linked and several non linked items, i need to highlight which ones are and which ones aren't linked.
Basically there is a field called a <MirrorWillCod> if this field has a linked item within the report then it will appear twice, if it only appears once then it is unlinked.
I need to give each some kind of marker so people using the report can see at a glance if an item is linked or not.
I'm a bit short of ideas but i have tried count<MirrorWillCod) and then where count = 2, but this didn't work as all the counts equaled 1..
Please help!!!
Basically there is a field called a <MirrorWillCod> if this field has a linked item within the report then it will appear twice, if it only appears once then it is unlinked.
I need to give each some kind of marker so people using the report can see at a glance if an item is linked or not.
I'm a bit short of ideas but i have tried count<MirrorWillCod) and then where count = 2, but this didn't work as all the counts equaled 1..
Please help!!!