Text object Display.

[#1]

I have data as below.

ID  Notes   EndDate

1   ABC     9/21/2016

1   AAA     7/22/2016

2   BBB     2/4/2016

I want to display in text object notes and Date together when ID is selected.So I have the below expression in text object.

=If(GetSelectedCount([ID]) > 0, DATE(EndDate) & ' - ' & Note)

This is displaying only one row of data for ID 1 where I want to show 2 rows of data for ID 1 in text box.How can I  do that ?

[neelamsaroha157]

Instead of doing this in Text object, try it with straight table and you can always change the look and feel of it as text object.

Something like this

[Anil_Babu_Samineni]

Let's Assume

if you select ID = 1 Then what are you expecting from Text object?

[sunny_talwar]

Are you sure you want to use text box object for this. If you do, may be try this:

=If(GetSelectedCount([ID]) > 0, Concat(Date(EndDate) & ' - ' & Notes, Chr(10)))

[susovan]

I know that its not a proper way.

But you can also try this attachment

.

[Anonymous]

you may use

=If(GetSelectedCount([ID]) > 0, concat(DATE(EndDate) & ' - ' & Note,chr(13))

but the best solution as neelam said use a straight table

[sunny_talwar]

Minor error in the expression. Here is the updated expression:

=If(GetSelectedCount([ID]) > 0, Concat(Date(EndDate) & ' - ' & Notes, Chr(10)))

[Anonymous]

Hi

Please find attached

Hope it help!!