Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Display Result in Crystal report

Purchase sales

PURCHASE amt 0
0 SALES Amt

The above result is not on same row It's Skip The same row of sales field I want it in Same Row as Below
Purchase sales
PURCHASE amt SALESAmt

What is the problem with it?. Why the data not show in same rows and How to do it?.




table strucure

trading type || amt || Date
============ ===== ==========
Sale || 100 || 12/2/2012
Purchase || 50 || 13/2/2012
Sale || 75 || 14/5/2012


i wnat to into report
Trading Type|| saleAmoutn || trading Type || PurchaseAmt
Sale || 100 || Purchase 75
Sale || 75 ||

not like this
Trading Type|| saleAmoutn || trading Type || PurchaseAmt
Sale || 100 || || 0
Sale || 75 || || 0
|| 0 || Purchase 75
Posted
Updated 1-Apr-14 0:57am
v3
Comments
thatraja 1-Apr-14 6:08am    
Include table structure, sample data, query & report screenshot in your question

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900