Cognos 8 RS grouped data - prompt option to display records with count > 1

[schurers]

Cognos 8 Report Studio question -
I have data grouped by customer number and I am counting the number of contracts for that customer. I want to know if I can provide the user with a prompt where he can choose to display only those customers whose contract count is > 1 or display all customers.

Ex:
Customer ABC
Contract 3542324 Amt
Count = 1

Customer EFG
Contract 2452452 Amt
Contracat 425252 Amt
Count = 2

Can I give the user an option to run the report to show only those customers that have more than 1 contract (customer EFG) or an option to select all customers (Customers ABC and EFG)
Thanks in advance for any answers!

 

[blom0344]

Use another text box prompt with static values 1 and 2 with the parameter 'counter'

Then use a filter (after auto aggregation) in the data-query that refers to this parameter:

[count data item] >= ?counter?

Ties Blom