Hi,
I managed to install Report Studio and i published sales_pkg, when i create sample report using this package i am getting below error,
An error occurred while performing operation 'sqlOpenResult' status='-28'.
(UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Arithmetic overflow error converting expression to data type int.)
But i have selected only one field (Country code), still getting same error. The respective table is having only 10-15 records.
I have tested the connection via framework manager and it is fine, i am getting data in framework manager.
Regards,
Raj
1st Check your sales_pkg connections just test the connection
2nd in FM click on data source and change database to native(local)
In FM double click on any table and click test check u getting values or not.
3rd check cognos content store started or not.