I’ve created a report with the form wizard (the report type form of SL 9.01) that displays data of the revenue milestones requirements of certain projects. To do that I use a secondary collection to populate the Details table (because the reporting manual says you can’t do that with a subcollection property). Additionally I show the project customer addresses with another secondary collection (SLCustAddrs).
Everything seems to be working fine when I run the report with the form controls. All the data is exported correctly to the pdf.
However if I run the report with a background task, the addresses are missing.
I have no idea why this happens. I’ve tried to set the addresses flex as another detail type flex and link it to the secondary collection, adding hidden fields with the secondary collection fields I use in the permanent filter in case it was a problem of accessibility, and tried different form events to refresh the collection… nothing works. I even traced the process with the SQL Profiler and the custaddr query is executed correctly.
Do you know a way to solve this without having to add the addresses as new properties of my main IDO?
Thanks in advance.
