Cognos 11 Active Report - Repeater Table Repeating too Many Times

[pacificbeavs]

I have a data list and a repeater table.

I have a filter relationship between the data list and the repeater table, so that the data list items when clicked will filter the repeater table.  However, when I run the report the repeater table repeats for every scenario from the data list, and then reduces down once a record from the data list is selected.

For example, let's say the data list has 15 stores, and the repeater table shows sales metrics by department.  I would expect that the repeater table would repeat 5 times, and then you would click on the various stores in the data list to filter the repeater table data.  However, instead when you run the report the repeater table values repeat 15 times, and then reduce down to one instance once an item from the data list is selected. 

Do you know how to set it up so that the repeater table doesn't repeat for each scenario in the data list?

[MFGF]

I have a data list and a repeater table.

I have a filter relationship between the data list and the repeater table, so that the data list items when clicked will filter the repeater table.  However, when I run the report the repeater table repeats for every scenario from the data list, and then reduces down once a record from the data list is selected.

For example, let's say the data list has 15 stores, and the repeater table shows sales metrics by department.  I would expect that the repeater table would repeat 5 times, and then you would click on the various stores in the data list to filter the repeater table data.  However, instead when you run the report the repeater table values repeat 15 times, and then reduce down to one instance once an item from the data list is selected. 

Do you know how to set it up so that the repeater table doesn't repeat for each scenario in the data list?

Hi,

The repeater table will repeat the same number of times as the number of rows available to it in the query. If you are not filtering initially, it will repeat for each of the rows (15 in your case). I'm not quite sure how you are arriving at it repeating 5 times initially? What in your report is identifying the correct 5 rows to display?

Assuming you want something different when the active report variable is not set (ie when you haven't selected an item to filter on) you could use the approach of using a deck with a single defined card containing your repeater table and with the default card enabled, containing whatever you want to display before making a selection. You could have your list set a variable that triggers the defined card at the same time as filtering the repeater table.

Cheers!

MF.

[pacificbeavs]

Thanks for the reply MF.  I will give that a shot; sounds promising.

As for your question on repeating 5 times... I stated that wrong, so disregard :).

-Wade