Topic
  • 1 reply
  • Latest Post - ‏2013-05-02T19:09:25Z by OpherB
FatimaShahul
FatimaShahul
4 Posts

Pinned topic Export issue when Exporting Cognos 10 Report to CSV format

‏2013-05-02T14:50:25Z |

Hi,

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

Thanks

  • OpherB
    OpherB
    732 Posts

    Re: Export issue when Exporting Cognos 10 Report to CSV format

    ‏2013-05-02T19:09:25Z  

    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.

     

    Good luck,

    Opher