Report column with matching rows

[2005 IR Help]

By: OhhWonder - ohhwonder

Report column with matching rows

2005-11-21 22:42

I have no idea how to match row with column. I will explain my self.

For example,

Column Header as below

 

|Product | Quitity | Date | Credit Card | Cash |

 

Below are simple query;

 

select pName, quitity, date, paymeth, amount from order ditail

 

Report will match pName with Product and quitity with Quitity. But for amount I need to be able to put amount into Credit Card column if paymeth is ccredit and put into Cash column if it is paid by cash.

 

The reason is I would like to have sperate total in each payment method at the bottom.

 

I don't know what function I can work on or if there is any sample I would appricate.