Print Page | Close Window

Grouping Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Tips and Tricks Forum Discription: Have you learned some great tricks to share with the group? Post them here! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22384 Printed Date: 19 Apr 2024 at 12:41am Topic: Grouping Posted By: JRCharlie Subject: Grouping Date Posted: 07 Jul 2017 at 5:10pm Hi I Have a report with orders that I would to merge all the duplicate orders and add all the colors of all each order number. I have This Date |Order|Adress | Color | Jan5 | 1      | abc     | blue | Jan5 | 1      | ABC    | Green| Jan9 | 2      | DEF     | red | I woul like to have this result. Date|ORDER | Addres | Color Jan5| 1        | ADC     |   Blue, Green Jan9| 2        | DEF     |    REd Replies: Posted By: kevlray Date Posted: 10 Jul 2017 at 5:34am It probably could be done with a formula in the details that just added a new color to a global or shared variable.  You then would just display the variable in the group footer (along with the other data.  The details would be hidden.  You would need another formula to reset your variable to an initial value ('').

Print Page | Close Window