INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...This site is awesome!...Things I have been trying to figure out for weeks, I got the answer in hours!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming Tools > Cognos solutions Forum

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

Read More Threads Like This One

schurers (Programmer)

10 May 12 11:20

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 (TechnicalUser)

11 May 12 4:52

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Cognos solutions