I need to take the value in each record ( business_management_hierarchy.parent_name) and concatenate this value to the previous value, Creating a list separated by commas which is shown in a column from a table. Is this even possible. I'm guessing I need to handle this with a Variable somehow.
How is this done in Jasper? in Boxi we did it with variables and expressions. But in Jasper we did not find how to do it.
Any ideas or suggestions are very welcome!
INNER JOIN bmhier business_management_hierarchy
relationship_type.id = business_management_hierarchy.ci_rel_type
configuration_item_child.asset_num = app_extx.app_id
configuration_item_child.asset_num = 'IT0033'