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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by CMDorsey
-
Crystal formula with multiple conditions in each if statement
I need help with the following formula...I have multiple conditions in each if statement but not sure how to write the formula - if {SO_SalesOrderHeader.UDF_CONSOLIDATED_SHIPMENT} = "N" and {SO_SalesOrderHeader.UDF_ON_TIME_SHIPMENT} = "Y" and {SO_SalesOrderHeader.UDF_SHIP_ASAP} = "N" then "**...- CMDorsey
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
cell reference another sheet but reverse the sign
I need to reference a cell in another sheet - in sheet 2 cell A4 has a value of -25, in sheet 1 A4 I want the value from sheet 2, cell A4 but as a positive 25, any suggestions?- CMDorsey
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
New item ordered
I am a Crystal Reports novice now having said that... I need to create a report that that selects records from one table when they do not exist in another table - When an ITEM exists in the SO_SalesOrderHistoryDetail table but not the SO_LastPurchaseHistory. Any help would be greatly appreciated.- CMDorsey
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Open windows explorer
I am a novice when it comes to vbscript... I have the following vbscript - Set objShell = CreateObject("Wscript.Shell") strPath = "F:\atco\LanAir\Work Orders" strPath = "explorer.exe /e,""F:\atco\LanAir\Work Orders" objShell.Run strPath I have a variable my WO#, I need to add to the path the...
