Cognos repeater table question

[sbelli]

Hi,

I'm relatively new in Cognos reporting. My only tasks to this point have been lists. However, I need to create a Repeater table with each table using different criteria for the input. That's a future question on how to get that to work.

Right now, I'm having an issue understanding why Repeater tables only allow you to use data from one query that it creates. I have separate queries to get counts on the number of records that meet a condition (for example: counting applicants in a table where I have an expression condition of:

([Date of Proof Other Details].[Dueproof_Workday_NUM] - [Date of Proof Other Details].[STTS_Workday_NUM]) <= 1 and [Date of Proof Other Details].[CVR_STTS_DT] between [Date of Proof Other Details].[Start Date] and [Date of Proof Other Details].[End Date]

I have multiple queries increasing the difference calculation to 2, 3, etc. However, since these are different queries, it will not allow me to add them to the repeater table. I've also tried to add the fields to the Query for the repeater table in which case I usually get the "Cross Joins" are not permitted error.

Any suggestions????

Again, other than simple list reports I haven't done much else in Cognos and the training I had did not go into any detail on repeater tables.

Thanks!

 

[blom0344]

By definition each Cognos report object (list,crosstab, etc) is associated with just one query. However, we often get around this limitation by creating unions and use the resultset of the union for the reporting object.

Our experience with repeaters is not to good. If you can work out another approach, then try to stay away from them..

Ties Blom

 

[sbelli]

Thanks. I've rephrased my question in a different post as a result of trying not to use repeater tables.