Pull item once from grouping

[cognosehelp01]

Hey guys,

I'm having what I think might be a simple-fix issue (I hope).
Basically I am have a series of Discrepancy pages grouped by Discrepancy #. Each row within that Discrepancy # has Discrepancy Type and Corrective Action Descriptions.
Rows output as:
Discrepancy# - Discrepancy Type - Corrective Action Description
1 - 12 - Issue found
1 - 12 - Issue worked on
1 - 12 - Issue corrected
2 - 56 - Issue found
2 - 56 - Issue worked on
2 - 56 - Issue corrected

I want to get a count of the Discrepancy Types, but because it's repeated in every row I am getting a higher count than what's actually there.
How would I go about only pulling the Discrepancy Type once per grouping(Discrepancy #)?

Thanks!

[Lynn]

Hey guys,

I'm having what I think might be a simple-fix issue (I hope).
Basically I am have a series of Discrepancy pages grouped by Discrepancy #. Each row within that Discrepancy # has Discrepancy Type and Corrective Action Descriptions.
Rows output as:
Discrepancy# - Discrepancy Type - Corrective Action Description
1 - 12 - Issue found
1 - 12 - Issue worked on
1 - 12 - Issue corrected
2 - 56 - Issue found
2 - 56 - Issue worked on
2 - 56 - Issue corrected

I want to get a count of the Discrepancy Types, but because it's repeated in every row I am getting a higher count than what's actually there.
How would I go about only pulling the Discrepancy Type once per grouping(Discrepancy #)?

Thanks!

This is a duplicate post. Please read Forum Etiquette page.

http://www.cognoise.com/index.php/topic,26421.0.html