How to use an array (or generated xml string) from splitted string as datasource in subreport

[former_member1107748]

Hello community,

let's say i have data provided from third party software (that means, I can't influence the content), looking like this:

employee_name, date, courses, information_c1, information_c2, information_c3
"max", "2021-06-15", "c1, c2", "description_c1", "description_c2", "description_c3"
"kai", "2021-06-13", "c2, c3", "description_c1", "description_c2", "description_c3"

The main report contains values like name and date. Now, for each course attended (c1, c2, c3, ...) a subreport should output several information like course name (i.e. c1), a symbol (done with an if condition comparing "if course equals c1 print symbol_1, else if .. print symbol_2....) and the text of the infromation column belonging to the course. These diffent contents will have different font settings (font-family, size, underlinings, ...)

As far as I can see, to do so, it'd be necessary to split the string into an array and provide that array as the datasource for the subreport. But I can't figure out, how to do that. All examples with splitt-calls I could find, just use the splitted values directly in a formula, so the formatting options of subreports can't be used.

Alternativley I would also be happy with a solution to create a xml string using an aray locally in an formula and provide this xml string as datasource. But that ends in a similar issue - I can only find options to use xml data from a file from disk. Is there any option?
For processing a xml file I would have a working solution.

[former_member1107748]

The datasource provided from the third party software is a ms access db. From that one I get the data as shown in the example. Since it's comming from third party I'm unable to change the contents or data provided.

So my idea was to use variables to store (manipluated) data and use that as datasource in a subreport.