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