David: I am not familiar with the feature "SuppressRepeatedValues" but it sounds like something I could use; where do you find it? Have you tried marking just VRdate to "SuppressRepeatedValues" ? Also, even though you print the lines in the Detail section, have you tried adding a second break for Vendor? Maybe this will help with your line suppression. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of David M. Blocker Sent: Monday, July 11, 2005 12:40 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Suppress Repeated Values Overdoes it 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
