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