Is it possible to generate the report with out using FM at all..????
If YES....then how..??????(on SQL server 2005 )
Thankx in advance
It is possible..Use Tabular sql.
Kalyan
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
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