Hi, I'm new at Crystal Reports, I'm currently writing an windows app in Visual Basic 2005, part of Visual Studio 2005. All the info is written to a SQL Database, so most of the info I need is taken from there.
Recently I've been trying to make a Report where I need to compare the Income Orders and the Export Orders, my tables are structured like this:
Orden OrdenFinal Compra CompraFinal
Id_Pedido Id_Pedido Id_Pedido Id_Pedido
Id_Cliente Id_Producto Id_Cliente Id_Producto
PrecioTotal Talla PrecioTotal Talla
FechaPedido Color FechaPedido Color
FechaVen Cantidad FechaVen Cantidad
PrecioVenta PrecioCompra
PrecioTotal PrecioTotal
The only links which have the same info are
Orden.Id_Pedido->OrdenFinal.Id_Pedido
Compra.Id_Pedido->CompraFinal.Id_Pedido
What I want to show in the report is the amount of products by products, sale price and Total Price, One for the Income and One for the Export, and at the end show, how much money i spend buying and how much did I win.
If anyone can help me, I'm Thanking you in advance. I really need to get this thing going.
Thank You
Isaac
IP Logged
