How to display more than 1 name with its respective values in a text box...

[kavita25]

Hi...

How to display the names in one text box....and also its value as shown in below example.

Please help me to solve this issue, its an urgent...

For e.g

Kavita - 3000

ABC-  4000

Regards,

Kavita

[jonathandienst]

Add an expression to the text box, something like:

     =[Name] & ' - ' & [ID Code]

(replace the field names with the correct ones for your data model)

HTH

Jonathan

[kavita25]

I want it in front end....and the numeric value is the expression...

Regards,

Kavita

[amit_saini]

Hi,

Try this:

Name & ' - ' & Number

Thanks,

AS

[amit_saini]

Check attachment.

Here I have done with country and Revenue_id

Thanks,
AS

[petter]

You might be able to use the Concat()-function to help you:

=Concat( DISTINCT Company & ' - ' & Amount , Chr(10) )

This will concatenate the combination of Company field and Amount field and use carriage return to separate

the resulting rows... so it should work in a Text Box. You can also turn on vertical scroll bars in the text box if

you get too many rows to fit in the height.

[jagan · Accepted solution]

Hi,

Try using Concat() and Aggr()

=Concat(Aggr(Dim1 & '-' & Sum(Dim2), Dim1), chr(13))

Hope this helps you.

Regards,

jagan.

[kavita25]

Thank You Jagan...

The logics is almost as per the requirement, but the name and the respective values is conditional...

For. e.g If Sales is less than 9000 then, the given logic should be applied.

[jagan]

HI,

Try like this

=Concat(Aggr(If(Sum(Dim2) < 9000, Dim1 & '-' & Sum(Dim2)), Dim1), chr(13))

Hope this helps you.

Regards,

Jagan.

[nagarjuna_kotha]

Hi Kavitha,

Try below Expression.I hope this will work.

=[Emp_Name] & ' - ' & [Emp_ID]

Regards,

Nagarjuna