help with data display

• Lucky9

  Default port

  Points: 1470

  More actions

  February 14, 2012 at 8:24 pm

  #256863

  I have a report and the format of the report as below

  Client Name client Address

  ABC126 Avenue Street 12

  Job title

  Mr Smith CEO

  Mr Smith Manager

  I want to display Mr Smith only because both CEO and manager are same.

  and if it's same then i want to display only CEO's name as below

  Client Name client Address

  ABC126 Avenue Street 12

  Job title

  Mr Smith CEO

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  February 15, 2012 at 2:20 am

  #1447180

  kindly clarify

  1. Is Mr Smith's old designation was Maanger and now he is a CEO? if not how 2 dsignations.

  2. do you want the data in 2 lines.

  Regards
  Durai Nagarajan