hi!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!
SELECT distinct configuration_item_child.asset_num, business_management_hierarchy.child_name, app_extx.zClasificacion, configuration_item_child.class_type, business_management_hierarchy.parent_nameFROM ci_rel_type relationship_type, app_extx, nr configuration_item_child INNER JOIN bmhier business_management_hierarchy ON (business_management_hierarchy.child=configuration_item_child.id)WHERE ( relationship_type.id = business_management_hierarchy.ci_rel_type AND configuration_item_child.asset_num = app_extx.app_id AND configuration_item_child.asset_num = 'IT0033' )
Perhaps the link below helps?
list of comma separated values | Jaspersoft Community