TMcCrillis
IS-IT--Management
I'm new to crystal and know what I do only by "hands on", what I've figured out on my own... so be gentle....
I'm trying to calculate the # Days a product was on the shelf. I have records from the same table that I need to calculate and I don't have the first idea how.
I've created the main report (Part Number Info) and added a subreport to pull the transaction detail for that specific part number and sorted by serial number. Each serial number should have two records J55(off shelf) and J52(on shelf) among others. I need to get the datediff between these two records but I don't know how to evaluate records against themselves because these will post to the report as individual records, not as something that I can put into multiple columns. Once that is out of the way, I know how to evaluate days on shelf for a product that is still in stock.
I hope that explains it clearly. I'd appreciate any help.
I'm trying to calculate the # Days a product was on the shelf. I have records from the same table that I need to calculate and I don't have the first idea how.
I've created the main report (Part Number Info) and added a subreport to pull the transaction detail for that specific part number and sorted by serial number. Each serial number should have two records J55(off shelf) and J52(on shelf) among others. I need to get the datediff between these two records but I don't know how to evaluate records against themselves because these will post to the report as individual records, not as something that I can put into multiple columns. Once that is out of the way, I know how to evaluate days on shelf for a product that is still in stock.
I hope that explains it clearly. I'd appreciate any help.