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

Report does not display data in table on first run

Started by mrgoodbar65, 29 Aug 2011 11:07:33 AM

Previous topic - Next topic

mrgoodbar65

I have a report in COGNOS 8.2 that has two pages.  The first is a table that is populated with data items that are derived from a series of join and union queries.   All of those queries were manipulating a single Report Template.

When I run the report, the report will actually run but the table will only have the header row of the table.  The rows of data will not display.  The second page of data is a series of simple XY line graphs that have a master-detail relationship.   They will display even though the table data does not.   These graphs reference one simple query (no joins, unions, etc.).

If I run the report a second time, it will run as it should and display all the data in the table as well as the graphs.

I am assuming it has something to do with the amount and complexity of queries; however, at this point the data is just seed data and only a dozen or so rows so I wouldn't think there would be any issues.

This report is going to be set up on a schedule and I can't afford to have an empty table going out to users.   

Any help would be greatly appreciated.

rockytopmark

I don't believe the complexity has anything to do with it.

Are there parameters that aren't satisfied until the 2nd page loads?  Have you checked the tabular detail of the query that is associated with the "Table" on page 1?  Also, I assume you are saying "table" where you are actually talking about a List object... correct?  If not, then explain your setup better on Page 1

mrgoodbar65

Thanks for your reply.

First off, yes...by "table" I meant list object.  Sorry for the incorrect terminology.

Is there anything in particular I should be looking for regarding tabular detail?

Would it help to post the Native or Cognos SQL?