If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8.3 Report Studio report displays corrupted data

Started by bioCam, 02 Oct 2010 09:20:42 PM

Previous topic - Next topic

bioCam

This is rather strange ...

In FM, query_subject (QS) is a combination of query_items (QI) taken from 3 different tables; TableA has 3 items, TableB has 2 items and TableC has 3 items.  I am able to test the QS and see the correct 10 rows of data returned.  QS is then published as a package to Cognos 8.3.  I then dragged all 8 data items from this QS into the list report and run the report as HTML.  The result - no data was returned except TableB 2 column items showed corrupted data (like the square character and some garbled text).  If I removed the TableB 2 items from the list, and run the report, all the data would be displayed.  TableB items -- first -> CodeNumber (1 to 10), second - description.  If I remove the CodeNumber data item only, and run the report, all the data would be displayed just fine.  I tried running the report in Excel, CVS and the results are the same.  CodeNumber data seems to have a problem but what could it be??  Has anyone experienced similar corrupted data being displayed???

IceTea

If i were you i would check the generated SQL both in FM and the Studio. Are there differences?

Is the DataSource on your FM Machine the same as in your Cognos Server Data Sources?