Stimulsoft Business Intelligence System | Forum

Hey,

I'm trying to create a table where order dates are connected to a company name. I need to group those dates and have them in one line separated by ",".

Current Output:
Company name 1 ---- Order date 1
Company name 1 ---- Order date 2
Company name 1 ---- Order date 3
Company name 2 ---- Order date 1
...

Desired Output:
Company name 1 ----- Order date 1, order date 2, order date 3
Company name 2 ---- Order date 1
....

I created a sample file to show the current output.
I already tried "Func.EngineHelper.JoinColumnContent" for order dates but this will show all order dates for every company name on a databand.
Do you have any idea how to solve the issue?

Hello,

For the XML datasource, you can use the additional code in BeforePrint event of DataBand in which join necessary values.
For the sql datasource, you can use the JoinColumnContent() function and ReconnectOnEachRow option for the datasource.

Thank you.

Hello.

Here is a sample report template.
We use a variable to store the data in Before Print event of the Data Band. Thank you.

Thank you guys. Exactly what I needed. Excellent as always

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

I am trying to do just this within the Dynamic Report Designer UI. Could you tell me how this would be done within the UI? We need to tie an asset id to a work order id and then have the data populate based off the work order id.

Hello,

Please send us a sample report with test data with a detailed description for analysis.

Thank you.

HighAley wrote: ↑Fri Apr 22, 2016 11:51 am Hello.

Here is a sample report template.
We use a variable to store the data in Before Print event of the Data Band.
ConcatColumnInGroup.mrt
Thank you.

Hi, do you know why the variable is locked? I cannot see the code.

Hello,

The issue was in one of old builds 2015.x and was fixed. But variables created in this build need change. You can manually edit mrt file in notepad or use the following code: Thank you.