COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: diskette on 24 Aug 2010 05:35:38 PM

Title: Query detail on seperate page in the report (repeat from Query Studio)
Post by: diskette on 24 Aug 2010 05:35:38 PM

Hi ,

first post and all that blah blah blah.

im trying to get a head, in my job and the first thing i have spotted and hear is that all the users ask "the reports wrong" that because they cannot see the query the report is built on.  Is there a way to display the contents of each query and its title on seperate page in the report
Title: Re: Query detail on seperate page in the report (repeat from Query Studio)
Post by: blom0344 on 26 Aug 2010 03:25:41 AM
I would expect this to be difficult as the exact SQL is generated 'on-the-fly' against the related package. The query definition is not stored as part of the report xml.

Generally speaking, the SQL generated looks pretty complex due to the C8 modelling involved, which may not be a problem if your users are SQL experts. But users rarely are..