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

User generated Query in Report Studio

Started by gauravrajguru, 10 Apr 2006 09:07:52 PM

Previous topic - Next topic

gauravrajguru

Hi Guys,
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, I am pretty new to COGNOS and am working with Report Studio. I want to know how do you write user generated queries in report Studio for generating a report. I dont want to use the SQL generated by COGNOS. I would highly appreciative if you could solve my doubt.

TwoSnap

Are you are talking about using your own SQL?  Select 'Queries' from the 'Query Explorer', such that you can see all of the queries in your report, if any.  This should open up the Insertable Objects window on the left side.  Simply drag over the item named SQL and the rest should be clear.  Open the new SQL node it placed on the sheet and type in your SQL. 

Take a look at the new Union capability as well, it's pretty slick. 

Good Luck. 

t.