display the value based on expression

[ppreddys]

i am trying to create a report where i am grouping costumer name ,id ,dept,year, prev worked info and current work info.
under that for each customer id i have to stack up  like 20 different data items ( that i created have which  different scenarios (expressions). here my question is i have to display those data items  value  that satisfy for each customer is their any way  i can can use list or cross tabs ?


Please advice Thank You.


below is an sample example how report should look as you see for each Id it has the job change or new job added

ID  First Name   Last Name   Phone     E-Mail   Dept       AUDIT DATE   Previous                          New

xxxxx Erica              Aonk   xxxxxxxxx Email id  bba        9/25/2014       
Primary 1 Change:                                                                                 Management         General Business   
 

 
xyxyxy  Victoria Akpan xyxyxyx        email           bba       4/10/2015       
Add New join:                                                                                                                      Accounting   
Add New join2:                                                                                                                           Management