Hello, I created CF, I enabled him as visible for Report Designer in IFS Cloud. I see data from this CF in IFS Cloud, in Report Designer I see his name, but it retrieves no data, why?
Thanks
Solved
CF in Report Designer is not visible
Best answer by dsj
If you see the CF in report designer and don’t see data, it’s highly likely that you are previewing from a archive record which created before creating the CF. Print/Preview the report again in IFS cloud and use the generated archive key to preview the report from report designer.
Hope it helps!
Damith
+13
+22
If you see the CF in report designer and don’t see data, it’s highly likely that you are previewing from a archive record which created before creating the CF. Print/Preview the report again in IFS cloud and use the generated archive key to preview the report from report designer.
Hope it helps!
Damith
An old result key created prior to adding your new custom field would not work.
And for example:
SELECT
LISTAGG(
t1.component_part || ' - ' || t1.CF$_C_COMPONENT_DESCRIPTION,
CHR(10)
)
FROM table1 t1
JOIN table2 t2
ON REGEXP_SUBSTR(t1.part_no, 'M[0-9]+_[0-9]+') =
REGEXP_SUBSTR(t2.part_no, 'M[0-9]+_[0-9]+')
WHERE t2.order_no = :order_no
When I add this CF, it works, but when I want to add only component_desciption or component part, it doesnt work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.