SQL Query in Reports

[Kanag]

Hi Guys,
            Could you please let me know how to design a reports from the SQL Query?.....I am seeing "SQL" Option in Query explorer tab...

Would appreciate if you can let me know how to embed a SQL Query in Cognos report Studio!

Thanks,
KR

[RobsWalker68]

Hi,

In Report Studio, navigate to Query Explorer and then drag an SQL object from the left hand to right hand pane.

Choose whether you want to use Cognos, native or pass through SQL, select a data source and finally write the appropriate SQL

Kind Regards

Rob