Cross tab Crystal Report in Visual studio
-
Hi, This is the report format I need in Crystal reports. I tried with Crosstabs, but it comes wierd. Also I do not know how to get the amounts listed in columns month wise, it depends on a date field in the DB table named purchase_due_date. The client requirement is that I need to display the result an year's data when he selects a date. So client would input a date. It is also better if I can let the user provide conversion values for various currencies. Could anyone help me out with this?
Invoice Amount in Local Currency
Customer
PO Number
PO Value
Apr 08
May 08
Jun 08
Jul 08
Aug 08
Sep 08
Oct 08
Nov 08
Dec 08
Year 2009 Onwards
Row Total(In Local Currency)
Green Constructions
PO567
$400
100
100
100
300
John's Pizza
PO987
Euro 1000
200
500
700
Column Tot in
Local Currency100
200
100
500
100
1000
Cumulative Tot in
Local Currency100
300
400
900
1000
Regards, Blumen
“The thing for you is a burial permit. You have only to speak and I will see that you get it.”