COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nayitian on 16 Apr 2008 09:41:16 PM

Title: output csv file
Post by: nayitian on 16 Apr 2008 09:41:16 PM
Hi all,

I have a list report is stacked by two separate queries, if I run as csv format, I can only have the first query dumped out but the second one.
Is there any place that I can define to output both queries in one csv file?

Thank you.
Title: Re: output csv file
Post by: rockytopmark on 16 Apr 2008 11:11:50 PM
Yep, 1st query based object only with a CSV... sounds right.

If the two queries are similar in structure, UNION them into 1 single resultset and base a single list object from that "unioned" data.