David,
If the suggestions regarding the reset break setting don't do what you
want, consider concatenating the VRDate and Vendor fields in an expression,
and place the expression on the report with suppress repeated values set.
I'm having a small problem with the great feature
"SuppressRepeatedValues" in reports.
Consider this data of repairs on one vehicle in a fleet:
VRDate Vendor Work Cost
08/01/05 Joe's Garage Oil and Lub $20.10
08/01/05 Joe's Garage Change Spark Plugs $50.00
09/01/05 Joe's Garage Rotate Tires $25.00
09/01/05 Joe's Garage Drain AC $20.00
10/01/05 Al's Garage Tuneup $100.00
10/01/05 Al's Garage Replace wipers $11.50
Consider a report that breaks on VRdate with total Cost
in the break footer.
All data is placed in the DETAIL section.
I mark VRDate and Vendor to "SuppressRepeatedValues"
What I WANT is this:
Date Vendor Work Done Cost
08/01/05 Joe's Garage Oil and Lub $20.10
Change Spark Plugs $50.00
TOTAL: $70.10
09/01/05 Joe's Garage Rotate Tires $25.00
Drain AC $20.00
TOTAL: $45.00
10/01/05 Al's Garage Tuneup $100.00
Replace wipers $11.50
TOTAL: $111.50
But what I GET is this:
Date Vendor Work Done Cost
08/01/05 Joe's Garage Oil and Lub $20.10
Change Spark Plugs $50.00
TOTAL: $70.10
09/01/05 Rotate Tires $25.00
Drain AC $20.00
TOTAL: $45.00
10/01/05 Al's Garage Tuneup $100.00
Replace wipers $11.50
TOTAL: $111.50
This makes it look like the value of Vendor is NULL for 09/01/05
when it isn't. Is there a way to tell the report to suppress
repeated values WITHIN a break but always print it at the beginning
of a new break, even if it's the same as the last break?
The above behavior is in both of the latest releases of R:Base
7.1 and 7.5
David Blocker
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
