Joined: 06 Feb 2012
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: How do i Replace Duplicated Items Posted: 06 Feb 2012 at 11:36pm
I have produced a report which has several lineswhich a lot of the data duplicated
I dont want to show the duplicated items so i have formatted the field "Suppress if Duplicated" but i would like to show in the suppress space "Refer to Main"
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 08 Feb 2012 at 3:34am
what comes to mind is to create a label that says 'refer to main' and then in it's suppression formule (general tab/x-2 button) put something like:
{table.field} = previous{table.field}
the only caveat being, if you change groups and this field doesn't change, it will display message, as it only knows to look at the data....not where that data logically belongs.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum