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.

[ido_millet]

Simply use the MS Access database as the data source.

No need for acrobatics.