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???
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?