The field to a String

[Former Member]

Hello All, I have a problem: I have a field to return a few values, such as: 1; 2; 3. 3 values, there is no way to put these 3 values together into a comma separated string, such as: 1,2,3 ??

Thank you all.

[Former Member · Accepted solution]

The filed is from DB

[abhilash_kumar · Accepted solution]

Hi Alex,

1) Create a formula with this code and place it on the details section:

Whileprintingrecords;

Stringvar x := x & totext({database Field}) & (if not onlastrecord then ',');

'';

2) Create another formula with this code and place this on the report footer:

Whileprintingrecords;

Stringvar x;

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

1) these will get the complete String in the last record.

2) I had put Stringvar x in the report footer, but it is null.

how I can get the complete String in the report footer??

-Alex

[Former Member · Accepted solution]

Hi Abhilash,

Sorry Abhilash, the  String is show on the report footer,but I need to show on report header.

how I can get the complete String in the report header??

-Alex

[abhilash_kumar · Accepted solution]

You'll need a subreport to be able to display this on the Report Header.

Another way to do this is to create this string at the database side (via a SQL Expression or a Command SQL). You can then simply drag and drop the field on the header.

-Abhilash