Function

[rtrujillor]

Hi,

We are using Stimulsoft Reports JS, version 2018.2.1

We are trying to use the built-in function :

{Func.EngineHelper.JoinColumnContent(Standards, "value", ",")}

This is the object Standards:

"Standards": [
"ISO 9001:2015",
"ISO 14001:2015",
"ISO 45001:2018"
]

but is not working. Nothing appears as a result of evaluating the function. Is the function available in the version we are using?

We are expecting to have this result: "ISO 9001:2015, ISO 14001:2015, ISO 45001:2018", I mean to concatenate the string of each one of the array elements, using the comma separator.

The same expression but adapted to the specific Datasource, is working in any of the demo examples you provide in the Demo site ( https://demo.stimulsoft.com/)

This is the complete Datasource we are using ( JSON ):
{
"Tags": 0,
"Affiliate": "United Kingdom",
"ProposalType": "Initial",
"ContractDepartment": "GB\/WW",
"ContractNumber": "980290",
"ProposalDate": "2019-09-19T00:00:00",
"ContactTitle": "Mr",
"ContactKnownAs": "Glen",
"ContactSurname": "Peek",
"OutsideSales": "Paul Njuquna",
"CompanyName": "Dwr Cymru \/ Welsh Wather",
"Address": "Pentwyn Road, Nelson, Treharris, Mid Glamorgan",
"Position": "IMS Manager",
"PhoneNumber": "+447341074164",
"Email": "glen.peek@dwrcymru.com",
"Fax": "",
"Standards": [
"ISO 9001:2015",
"ISO 14001:2015",
"ISO 45001:2018"
],
"Accreditation": "UKAS",

"ProposedMainScope": [
"Potable water and waste water services managing the provision, distribution and treatment processes. The provision of education and recreation facilities. Contract management and support services within Dwr Cymru Welsh Water."
],
"LevelOfIntegration": "",
"LengthOfCertification": "3",
"FrequencyOfVisits": "Annual",
"NbOfEmployees": 300,
"NbOfShifts": 1,
"ProposedAuditSites": 4,
"TotalNbOfSites": 4,
"NbEmployesByShift": 300,
"FoodIndustryCodes": "",
"EAC": [
"27",
"39"
],
"NACE": [
"93",
"01"
],
"TechnicalArea": [
"27.1",
"39.1",
"EM28",
"EM42",
"OH11",
"OH6"
],
"APPLumpsum": "",
"RenewalMandays": "",
"PreAuditMandays": "",
"EarlyRenewalMandays": "",
"S1AMandays": "1",
"S2AMandays": "3",
"ReportMandays": "",
"AccreditaionFeeLumpsum": "",
"LicenceFeeLumpsum": "",
"RegistrationFeeLumpsum": "",
"SURMandays": "1.5",
"RAUMandays": "2.5",
"Currency": "GBP",
"DayRate": "960",
"VATNumber": "7711236543",
"RegistrationNumber": "9876453",
"SpecificAddInfo": "This is a multi-site certificate. Site details on defined on DCWW's contolled document SP01 - Issue 67 dated 17th May 2019. ",
"Sites": [
"Brecon Royal Office, 6 the Bulwark, Breacon, LD3 7LB",
"Dinas Office, Llanwnnda, Caernarfn, Gwynedd, LL54 5UD",
"Linea Office, Fortran Road, St Mellons, Cardiff, CF3 0LT"
]
}

What are we doing badly?

Thanks in advance,

[Lech Kulikowski]

Hello,

That function was added several versions again. Please check the last build 2019.4.2

Thank you.

[rtrujillor]

Hi,
Thanks for the quick answer, we will try to update to that version as soon as possible
BR

[Andrew]

Hello,

Okay, let us know about the result.
Thank you.