report w/o FM...??????

[pooja]

Is it possible to generate the report with out using FM at all..????
If YES....then how..??????(on SQL server 2005 )

Thankx in advance

[Kalyan cognoise]

It is possible..Use Tabular sql.

Kalyan

[DSR]

Hi,

For Creating report without FM....You need to create Data Source in Cognos connection and then you can write your SQL by using that Data Source for report.

Regards,
Sanjeev

[vinu]

You can create a report with out FM, but you should have a package in cognos connection to open report studio.

1.create a data source in cognos connection.
2.Open Report Studio
3.create a query in query explorer.
4.drag SQL from insertable objects into query
5.Write your own sql to create report
6.assign datasource to SQL from Properties pane.




Thanks,
Venu