Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I select the record with the latest date?
Thank you both for the info. Crystal ver - 8.5 DB - Oracle 8i I will try your suggestions. Thanks again.- MAKU40
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How do I select the record with the latest date?
Below is the selection criteria: ({TRACE_INV_TRANS.QTY} > 0.00) and ({INVENTORY_TRANS.WAREHOUSE_ID} = {?Warehouse} or {?Warehouse} = "ALL") and {INVENTORY_TRANS.LOCATION_ID} = {?Location} and (Date({TRACE_INV_TRANS.CREATE_DATE}) <= {?EndDate}) The last line is needed but that gives me ALL the...- MAKU40
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
