Liveware Publishing Support Forum

The database has been grouped by filed "a".__I want to display all groups in which field "b" doesn^t match througout the group.__I^m using R & R Report Writer 9.0.____How do I??? :(____Thanx tons,____~Sean :D

[updated:LAST EDITED ON Sep-25-03 AT 12:38 PM (EST)]So in this example:__FieldA FieldB__a a__a a__a b__b c__b c__b c____You would want to see the first group(a) and not the second group (b) since the second has all c^s in fieldB?____Kathleen__R&R Support

that is exactly what I^m looking for.____Thanx :7____~Sean

Kathleen,____To give you my specific example:____FieldA..FieldA1..FieldB__12345.....a.....02/14/03__12345.....a.....02/14/03__12345.....a.....03/09/03____12345.....b.....06/22/03__12345.....b.....06/22/03__12345.....b.....06/22/03____I have the database sorted first by FieldA (Order), then FieldA1 (Order Part).__FieldB (Trans_Date) is the field I would like to filter by.__I would like the results to display the first group (12345 a) because the dates are not all the same.____Thank you very much.____~Sean :D__

You could create two totals, one a min and one a max of the date field and reset at Field 1. Make each of these pre-processed. Then query to include all records where MIN is not equal to MAX.____Kathleen__R&R Support

Dear sweet Kathleen,____You saved me just in-time; my boss was at the edge of patience for that report which was necessary to fix a bug in our software. It worked like a charm. Thank you so much.____Sicerely,____Sean Rizzo :D