getting concated string from records in datatable

Stimulsoft Reports.NET discussion
re4gi
Posts: 13
Joined: Thu Sep 13, 2012 7:50 am

getting concated string from records in datatable

Post by re4gi »

Hello,

is it possible to created some concated string from records in datatable?

For example I have table Users and there are 3 records in there:

username
-----------
Bob
Dylan
Jeremy

I want to get concated string looked like this (Bob, Dylan, Jeremy).

Could you help me with it please?

Thanks a lot,

Regi
csbrogi
Posts: 89
Joined: Thu May 03, 2012 11:47 am
Location: Germany

Re: getting concated string from records in datatable

Post by csbrogi »

Hello
you ma use the new function JoinColumnContent

Code: Select all

{Func.EngineHelper.JoinColumnContent(DatatableName, "ColumnName", ", SN: ")}
Regards
Clemens
Markus Weiß

Re: getting concated string from records in datatable

Post by Markus Weiß »

Since wich version does this function exist?

I often had this problem in the past.

Markus
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: getting concated string from records in datatable

Post by HighAley »

Hello.

This feature was added few months ago.
Please, check your latest prerelease build.

Thank you.
re4gi
Posts: 13
Joined: Thu Sep 13, 2012 7:50 am

Re: getting concated string from records in datatable

Post by re4gi »

Is it possible to use this function in Stimulsoft Report.Web as well?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: getting concated string from records in datatable

Post by HighAley »

Hello.

Yes. You could use it in Reports.Web.

Thank you.
re4gi
Posts: 13
Joined: Thu Sep 13, 2012 7:50 am

Re: getting concated string from records in datatable

Post by re4gi »

And the last question, could I find this function in Demo version as well?

Thank you for answers.

Regi
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: getting concated string from records in datatable

Post by Alex K. »

Hello,

Yes. Please download the last prerelease build from our site:
"Prerelease Builds (Trial Versions)"
http://www.stimulsoft.com/en/downloads

Thank you.
re4gi
Posts: 13
Joined: Thu Sep 13, 2012 7:50 am

Re: getting concated string from records in datatable

Post by re4gi »

I have two data tables which are in relation, is it possible to have the concated string only from the records from the child table which are related with the record from the parent table?

Thanks.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: getting concated string from records in datatable

Post by Alex K. »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ReportSample.mrt
(18.74 KiB) Downloaded 211 times
Post Reply