I am having a report that has a list and sublist (Master / Detail relationship) and it runs fine on html but, when we export the report to CSV format, it only exports the list columns and skip all sublist columns.
The column header is ignored and the column data is skipped for all items on the sublist.
Can anyone provide me the workaround for this problem?
Version: Cognos 10.1.1
Pinned topic Export issue when Exporting Cognos 10 Report to CSV format
OpherB 270003XT4A822 Posts
Re: Export issue when Exporting Cognos 10 Report to CSV format2013-05-02T19:09:25ZThis is the accepted answer. This is the accepted answer.
I seem to recall that this is how export is supposed to work by design. There is no way to support master/detail output in CSV exports. Most people build two version of the report - one for HTML output and a separate one for CSV which re-works the queries so there is only one.