7 Replies Latest reply: Sep 22, 2009 7:01 AM by richy RSS

    Query for a list of persons in a Chart

    Sravan Puppala

      I have a Diagram in which in one of the formel, I need to show the names of the workers in the company...

      I have a code like this

       


      = if ( isnull(P_LASTNAME)
      ,
      '-'
      ,
      if (len(P_LASTNAME & ', ' & P_FIRSTNAME)<25
      ,
      P_LASTNAME & ', ' & P_FIRSTNAME & chr(10) & chr(10) & P_TARIFGRUPPE
      ,
      P_LASTNAME & ', ' & FIRSTNAME & chr(10) & P_TARIFGRUPPE
      )
      )
      [/Code]

      The above code was for one person but now I have a Problem that there is a list of such names and I have to show all the Workers in this Query.
      Any Ideas???</body>