If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

run multi lists in report as CSV

Started by flower, 22 Mar 2010 08:26:54 AM

Previous topic - Next topic

flower

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

rockytopmark

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.