Skip to Content
0
Former Member
Apr 13, 2007 at 04:11 PM

Need to do data selection on a column basis.

11 Views

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.

5100.HOURS

5100.OT

5100.ONCALL

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?

Thanks,

Rick