Post reply

duplicate fields suppress

  • August 31, 2011 at 2:21 am

    #243120

    Hi

    I have a report which has 5 columns.

    I am wanting to supress only the first 4 columns of a row if they are they same as the previous row for the 3 columns only

    When i click on the field and hide duplicates it only give me the option for the Details or Group which is for the whole row, but I only want it to supress the first 4 columns. as Highlight in red below.

    Example.

    2221 Grounded 1.50 345 Coffee is grounded to check

    2221 Grounded 1.50 345 for instant aroma

    Does anyone know if this is possible?

    Thanks

    R

  • August 31, 2011 at 3:22 am

    #1375352

    I found the answer, for anyone that has had the same issue.

    I used an expression for the field

    =IIF((Previous(Fields!Division.Value)=Fields!Division.Value) ,"", Fields!Division.Value)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply