29.09.2026
09:17
Hi all,
I'm running into a problem with a SQL-based report in WEBCON BPS. I need to pull data from an item list (WFElementDetails) so that each list item (DET_ID) becomes a separate report row, instead of one aggregated/concatenated value.
Normally I'd just add the item-list column directly through the built-in report column picker, but I can't use it — the column on the form has restricted visibility, and the "report visibility independent from form visibility" checkbox for item-list columns doesn't work for me (checking it doesn't change anything; the column still isn't available as an option in the report configuration). Screens ( column wont show up on raport )
So I'm trying to work around this with SQL in a calculated report column. I've managed to get something working that pulls all values from the list concatenated into a single cell (separated by ;):
(SELECT
CONVERT(varchar(50), d.DET_Value11) + '; '
FROM WFElementDetails d
WHERE d.DET_WFDID = wfelems.wfd_id
AND d.DET_WFConID = (SELECT WFCON_ID FROM WFConfigurations
WHERE WFCON_GUID = 'dfb85f1c-84a0-48ce-b7ee-9379e5815937')
FOR XML PATH(''))
This works, but it's not what I actually need — I need each DET_ID from the list to end up as its own report row, with its corresponding DET_Value11 value (so an element with 3 list items should produce 3 report rows, not 1).
Has anyone solved a similar problem — a report with one row per list item instead of one row per element?
