Sale and Purchase in Same Row I crystal repoert
Please Check Upload File
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Snehal PatelPosted Mar 14, 2014, 7:44 AM
IN FILLED NAME TRAD_Type (sale or Puchase )
Qunatity
and table Record No TRAD_Type Qunatity
1 Purchase 50
2 sale 90
3 Purchase 80
4 Sale 60
5 Purchase 100
6 Sale 80
7 Sale 60
8 Purchase 10
i want to repoert like this
Purchase Sale
1 50 90
2 80 60
3 100 80
4 10 60
not likeethis
Purchase Sale
1 50 Blank Space
2 Blank Space 90
3 80 Blank Space
4 Blank Space 60
5 100 Blank Space
6 Blank Space 80
7 Blank Space 80
8 10
Jignesh TrivediPosted Mar 14, 2014, 7:05 AM
hi,
You can do one thing, get the result with in SQL query whatever you want.
can you please share information like table structure, relation between tables and some test data?