Post Author: rconner
CA Forum: Data Connectivity and SQL
I need to do different data selection on a column basis instead of on the whole report. Example, I have 3 General Ledger account numbers.
I need to see the units for each of these accounts per customer. My report lists each of the 3 accounts on separate rows and I need them to be side by side in order to do caluculations on the 3 fields.
Th report should look like:
Customer Name Account HOURS Units OT Units ONCALL UNITS Total
XYZ Corp. 5100 Hours 15 OT 3 ONCALL 2 20
At this time the report looks like the example below:
XYZ Corp. 5100 Hours 15
XYZ Corp. 5100 OT 3
XYZ Corp. 5100 ONCALL 2
Does anone know if this is possible and if so, how to do it?