7 Replies Latest reply on May 29, 2017 2:57 PM by Sravan Gereddy

    supressing a row in OBIEE 11

    user1106547

      hi have a simple report that shows patient appointments.

      some patients have more than one appt on any given day.

      the analysis gets extracted to SMS provider so we send duplicate messages if patient has more than one appt on same day.

       

       

      name    appt date      appt time   appt key
      smith     1/10/17          09:30          1234

      jones     1/10/17         10:00          1235

      jones     1/10/17          10:30          1235

       

      so in example above just what to show jones once - suppress or exclude the bottom row...

       

      any ideas?

       

      thanks