Jump to content
Changes to the Jaspersoft community edition download ×

Report column with matching rows


2005 IR Help

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...