nonWorkDays collection not showing up in exported reports

[tibormolnar]

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

[skyehansen]

It might not be you doing something wrong. Some collections just don't seem to download! When this happens to me, I do try all the valueformats I know about, and then just submit a ticket to Support asking if the data is supposed to be able to be downloadable too (if you're an authorized support contact) -- they are pretty good at helping out with that sort of thing.