COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: flower on 22 Mar 2010 08:26:54 AM

Title: run multi lists in report as CSV
Post by: flower on 22 Mar 2010 08:26:54 AM
Hi,
I have a report that has 5 different lists on the report. When I run the report as html, pdf or Excel, it shows each list.  But when I run as CSV (delimited) I only receive the first list.  How do I fix that?

-f
Title: Re: run multi lists in report as CSV
Post by: rockytopmark on 26 Mar 2010 09:40:16 AM
You are trying to do something that isn't possible.

A CSV, Comma Separated Value file, is the textual equivalent of a database table, so its structure is bound to 1 and only 1 query.  The main purpose of a CSV is to act like a table for exporting data to other applications. 

For your implementation, I would suggest having these 5 different list queries defined as 5 separate query subjects in FM and then set to be published as CSV (externalize method), so as to skip the Reporting Environment, and give you your desired CSV output with a simple 1 step process.