latest posts

If you use "DET_Value", remember to set "Decimal number".

What do you mean by "crashing report"?
I checked, and filtering works correctly for me.

Yeah, I added myself — that didn't help. I added my account as well, and the columns with restricted visibility are still not visible to me

Oh yes that work might be enought for me, but using filter Empty Value or Not Empty Value crashing Report ( Updated I chancge type data and not crusing anymore )

Hi,
when you check the box " Visibility on report independent of visibility on form", you should also fill in which users are allowed to see this column on the report in big filed above the checkbox.
If you won't tell the system who can see the column - nobody will be able to see it :)

Hi,
I'm not sure if I understood correctly, but if you are already using columns from that list in the report, you can simply enter DET_Value1 in the calculated column.

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?