Single cognos report multiple data sources

Stpes

1.    Get ready with SQL query

2.    Open report studio with/without any package

3.    Go to query explorer

4.    Drag query1

5.    Drag SQL object from Toolbox to query explorer

6.    Click on SQL object

7.    Properties pan select data source (Which you should have to created data source before for given SQL)

8.    Double click on SQL object

9.    Copy query into SQL ojbect

10.  Validate SQL

11.  Click ok

12.  Now you can design report

13.  Same way you can develop multiple query with multiple data sources report