I use Crystal Reports 10.0 for report writing accessing MS SQL 2000 database. Let me explain using an example.
I want to query the DB for 200 part numbers. I will sum the inventory on-hand to compare to the quanity on-order for a given sales order. As the inventory on-hand compares to quanity on-order as soon as I get the first negative inventory on-hand balance I want to report that record only. The information I would like to bring forward to the report is the part number, balance, date/time value when there is the first negative balance.
Please point me in the right direction as to how to write a formula. Any help would be greatly appreciated. Thanks.
I want to query the DB for 200 part numbers. I will sum the inventory on-hand to compare to the quanity on-order for a given sales order. As the inventory on-hand compares to quanity on-order as soon as I get the first negative inventory on-hand balance I want to report that record only. The information I would like to bring forward to the report is the part number, balance, date/time value when there is the first negative balance.
Please point me in the right direction as to how to write a formula. Any help would be greatly appreciated. Thanks.