Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Grouping Post Reply Post New Topic
Author Message

Joined: 25 Apr 2015
Online Status: Offline
Posts: 15
Quote JRCharlie Replybullet Topic: Grouping
    Posted: 07 Jul 2017 at 5:10pm
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

IP IP Logged
Admin Group
Admin Group

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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 ('').
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.