Display values from list box to text Object

[noman212]

Hi Community,

I have a List Box which display values from table i want to display  top 5 values separately in 5 text Objects..

Like

Text Object 1 Contains first value from the list Box

Text Object 2 Contains Second value from the list Box

Text Object 3 Contains third value from the list Box

Text Object 4 Contains fourth value from the list Box

Text Object 5 Contains fifth value from the list Box

Need your help..

Regards

Noman khan

[PrashantSangle]

If list box contain numerical value.

Then try

max(filedname,1)

max(filedname,2)

max(filedname,3)

max(filedname,4)

max(filedname,5)

Regards

[noman212]

This is Ok but i want to display related data for top 5 clients

Like client 1 have to pay premium 500K and his sum assured is 123K and his Consultant name is XYZ i want to Show these informations in a separate textbox like

Client = John

Premium  = 5000

Sum Assured = 250

Consultant name = XYZ Bank.

[sunny_talwar]

Try this may be in a list box:

For Max fieldname

='Client = ' & Only({<fieldname = {"$(=Max(filedname,1))"}>} ClientName) & Chr(13) &

  'Premium = ' & Sum({<fieldname = {"$(=Max(filedname,1))"}>} Premium) & Chr(13) &

  'Sum Assured = ' & Sum({<fieldname = {"$(=Max(filedname,1))"}>} [Sum Assured]) & Chr(13) &

  'Consultant Name= ' & Only({<fieldname = {"$(=Max(filedname,1))"}>} [Consultant Name])

For 2nd Max fieldname

='Client = ' & Only({<fieldname = {"$(=Max(filedname,2))"}>} ClientName) & Chr(13) &

  'Premium = ' & Sum({<fieldname = {"$(=Max(filedname,2))"}>} Premium) & Chr(13) &

  'Sum Assured = ' & Sum({<fieldname = {"$(=Max(filedname,2))"}>} [Sum Assured]) & Chr(13) &

  'Consultant Name= ' & Only({<fieldname = {"$(=Max(filedname,2))"}>} [Consultant Name])

and so on...

HTH

Best,

Sunny