Recent content by kwj1027

Thanks PH but that only sets the variable within the script. I need to have the variable set as an environment variable to the system. Regards, Kevin

Thanks PHV - appreciate the response. This is what I have and it works to the extent of echoing (displaying) the serial number. Set objFso = CreateObject("Scripting.FileSystemObject") Set drive = objFso.GetDrive("C") With drive Wscript.Echo "Serial Number:", .SerialNumber End With What I...

Greetings, I am not well advised in scripting enough to 'query' the system and need a quick solution that is hopefully not too difficult. Just breaking into VB Scripting and such so would like to find something that will integrate into a batch file. I need to read the serial number from...

Excellent PHV! Works like a charm now appreciate your assistance and time! KWJ1027

Greetings, I am attempting to determine yesterday's date with the code below. %YDAY% is coming back as 6, today is the 8th so I am expecting 7. I am going buggy trying to figure this out. Open to easier methods as well if there are any. @echo off echo WScript.Echo...

Amazing what the lack of sleep can do for a body and mind. I found my error when I came back to it - had an 'extra' count in the formula: if IsNull({@USE BY WO}) or Count (SHOULD NOT BE HERE) ({@USE BY WO}) = 0 then 0 else Count ({F57041.Q1$UNT}, {F57041.Q1TDTE}, "daily")/{@USE BY WO} Thank...

Sorry was hoping that I had provided enough information. IS the number of seconds between Min and Max of {F57041.Q1TDTE} resulting in formula calculation {@USE BY WO}. {F57041.Q1TDTE} is from the detail of the report. Count ({F57041.Q1$UNT}, {F57041.Q1TDTE} is the count of $UNT for each...

Greetings, I am running CR 10 reporting running against reports in JDE. Attempting to calculate the average time per piece for production. Qty/Ttl Seconds with the formula: if IsNull({@USE BY WO}) or Count ({@USE BY WO}) = 0 then 0 else Count ({F57041.Q1$UNT}, {F57041.Q1TDTE}, "daily")/{@USE...

I am running Crystal Reports 10. The scenario is that I have to two tables, one contains Work Order information consisting of WO#,System, Date, Start and End Time. The second table contains Test Results consisting of; System, Result Date and time. The link is on BCS and Date. I need to...

LB Just a little slow here on this Monday - must account for the long weekend I took. Worked beautifully after moving the text box (my duh) to a formula. Thank you for your assistance and patience on helping me through this. regards, KJ

Hi LB, Tried what you mentioned above and all the rows are 'silver.' I placed the variable statement in each visible group (both header and footer)in a text box. I then copied the formula in the Section Expert under the color tab for the desired group. Am I doing something wrong? KJ

Thanks RobbieB, given that I am looking for this on Group4 that would explain why it is not working. Appreciate the response and information. Regards

Greetings, I am using CR Ver 10. The report that I am creating suppresses the detail and only lists out groups for the information. I am trying to put a green bar effect on the report with the following set in section expert using the color tab: if remainder(groupnumber,2) = 0 then crsilver...

LB, Excellent worked perfectly! Thank you for your time and assistance. Regards, Kevin

Trying to create a formula to select records from yesterday and today with: Iif (Between ( {@REQDATE}, CurrentDate, CurrentDate-1 ) , {'Actual'} , NULL ))) Getting the error message ") is missing" and (Between is highlighted. {@REQDATE) } is a date field from JDE that is created with the...