Show only once

• varunkum

  Default port

  Points: 1481

  More actions

  June 13, 2011 at 12:25 pm

  #242060

  I HAVE A REPORT WITH PUBLICATION, DATE, ACCOUNT. Multiple accounts have same publications so i don't want to see them repeating in each row. Only if there is a change in publication i want to see the publication name in my report. Basically when ever there is a change i publication name i want to see the name.

• avitale

  SSC Eights!

  Points: 915

  More actions

  June 16, 2011 at 1:20 pm

  #1340037

  I'd say try a matrix or tablix and group by Publications.

  Then for the report title, you coul try something like

  =Join(Fields!Publication.value, ", ")

  or whatever your publications field name is.