Question
nonWorkDays collection not showing up in exported reports
Hello,
I need to be able to export the list of "Exceptions" (i.e. public holidays) for each of our schedules. So I've created a report on Schedules that includes the following column:
displayname=nonWorkDays
listdelimiter=,
listmethod=nested(nonWorkDays).lists
textmode=true
type=iterate
valueexpression=CONCAT(STRING({nonWorkDate}),if(isblank({scheduleDay}),'','#'),STRING({scheduleDay}))
valueformat=text
This works like a charm on the screen, but as soon as I export the report data, the nonWorkDays column is empty.
I've tried using another listdelimiter, changing valueformat to HTML, and also replacing the valueexpression with valuefield=nonWorkDate (for simplicity), still no joy.
If I create a project report and include the collection of the tasks, as follows, the collection is included in the export file:
displayname=Project Tasks Names
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML
I wonder what I am doing wrong.
I appreacite any help or ideas.
Thank you,
Tibor