concat values of a field.........

[#1]

Hi all,

I have two tables A, B. table A and B is joined by column  id . i have created a straight table with  column att_name  as a dimension from table A and 4 expressions . i have text box which should display att_name_desc for all 4  expressions from table B when I select att_name in straight table. i am using

                                     concat(att_name_desc ,',')

in text box which works fine if I have one id for each att_name. but I am not getting any att_name_desc if I have 2 or more id.

can some one suggest a solution.................

Thanks in advance

[#2]

hi

try this

Aggr(concat(att_name_desc ,','),att_name)

[#3]

hi Kumar,

I have used formula you suggested .i am getting att_name_desc for all att_name.but I need only

att_name_desc for selected  att_name in straight table

[ashwanin]

Hi Charan,

Please gp through the below.

I believe it is as per your requirement.

[christian77]

Hi.

Have you tried concat(DISTINCT field)?

[#6]

I am getting att_name_desc and att_name from two different tables

[#7]

I tried it.but I am not getting results as expected

[christian77]

Send an example.

You want to caoncat fields?

Field1 & Field2

[ashwanin]

Hi Charan,

If you have these fields in your tables then it will work.

Can you please post a sample to check it furthur?