Export issue when Exporting Cognos 10 Report to CSV format


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