COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dumbell on 11 May 2009 06:00:01 PM

Title: detail query item in master detail not showing up when output is csv
Post by: dumbell on 11 May 2009 06:00:01 PM
Hello everyone,

When I tried to produce csv output of a list,having master detail relationship in it,
the detail section item(s) are not showing up.

When looked up, RS user guide says "you cannot run  a report in xml or csv format if it has more than one query unless other queries are used as prompts."

I made a prompt off of the detail query. Still  they are not showing up in the list.

Please help!

Dumbell
Title: Re: detail query item in master detail not showing up when output is csv
Post by: dumbell on 12 May 2009 05:31:33 AM
Never mind, I got this solved by making explicit join between 2 queries.

Dumbell