exclude data using a running total

[shelby101]

Hi,I'm need to exclude specific data from a very basic crystal 2011 report. I have identified the data that I need to exclude and I can surpress the data, I need to also only get the actual total count. Goal is to only select the Orders with only 1 TaskNoteID and exclude that OrderID all together. Lines highlighted is the desired result. Please help
Sample how data looks now:
TaskNoteID OrderID RT
59,112 22,651 1.00
59,113 22,651 2.00
59,162 22,651 3.00
60,250 22,651 4.00
[highlight #FCE94F]61,301 24,461 1.00[/highlight]
[highlight #FCE94F]61,483 24,875 1.00[/highlight]
59,225 26,866 1.00
59,226 26,866 2.00
59,374 26,866 3.00
[highlight #FCE94F]59,505 26,916 1.00[/highlight]
[highlight #FCE94F]60,203 26,925 1.00[/highlight]

 

[kray4660]

If you have a definable criteria. You can make a running total and only evaluate on a formula.

 

[shelby101]

Hi,

I tried that, the problem is the 1. My desired result is to only get the orders that had only 1 note.

 

[kray4660]

I think will need to group by the TaskNoteID, in the group footer do a count of TaskNoteID, then create a running total (again in the group footer) that only evaluates when the count = 1. I have not tried this solution. There are other possibilities (manual running totals).

 

[shelby101]

still not getting the correct results. trying a 3 part variable to see if that helps. Thanks for the info tho, I appreciate it.

 

[pmax9999]

I would do it this way.
[ol 1]
[li]Create a Group on OrderID[/li]
[li]Use the following Group Selection formula
[Code - GroupSelect]
COUNT({TaskNoteID}, {Table.OrderID}) = 1
[/Code]
[/li]
[/ol]

If you want to count the OrderID field, use a Running Total, Distinct Count of {Table.OrderID} using the above evaluation formula.

Hope this helps.

Cheers
Pete