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

Query detail on seperate page in the report (repeat from Query Studio)

Started by diskette, 24 Aug 2010 05:35:38 PM

Previous topic - Next topic

diskette


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

blom0344

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..