I am trying to create a report where sum of amount would be displayed in 3 different columns based on what is in EDLCode field.
If EDLCode IN (501,502,503) Then Sum(Amount) in Column1
If EDLCode IN (505,506) Then Sum(Amount) in Column2
If EDLCode IN (1500) Then Sum(Amount) in Column3
Let me know if this makes sense. I am getting the report to work when I put fields in detail section but I need only one line per employee, so I am using Group Header and it shows 0 in column 2 and 3.
Final data should look like:
EmployeeName Column1 Column2 Column3
My ultimate aim is to concatenate all this fields in 1 field and be able to send as fixed width file.