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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kwj1027

    Drive Serial Number

    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
  2. kwj1027

    Drive Serial Number

    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...
  3. kwj1027

    Drive Serial Number

    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...
  4. kwj1027

    Yesterday in wscript

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

    Yesterday in wscript

    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...
  6. kwj1027

    Another Division by Zero problem

    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...
  7. kwj1027

    Another Division by Zero problem

    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...
  8. kwj1027

    Another Division by Zero problem

    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...
  9. kwj1027

    Between solution

    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...
  10. kwj1027

    Greenbar affect on Groups

    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
  11. kwj1027

    Greenbar affect on Groups

    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
  12. kwj1027

    Greenbar affect on Groups

    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
  13. kwj1027

    Greenbar affect on Groups

    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...
  14. kwj1027

    Another Date Question - Iif Between

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

    Another Date Question - Iif Between

    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...
  16. kwj1027

    Green Bar effect in Crystal Report

    Excellent! That did exactly what I needed for it to do! Appreciate the prompt and effective reply. In the future I will be sure to post pertinent information. REgards, KWJ
  17. kwj1027

    Green Bar effect in Crystal Report

    Alas, I am pretty certain that I have seen the answer here before but a search turned up nothing so I must ask the question: How do I create a formula that makes a greenbar (paper) effect on my report rows? Your assistance is appreciated. Regards, KWJ
  18. kwj1027

    Net Use Error Levels

    Greetings, After extensive searches with every major search engine using every combination of keywords I can think of I have reached the end of the 'net without my answer. Hopefully somewhere here can help. I need the list of error level codes returned from net use for a script file that I am...
  19. kwj1027

    Sum of Formula

    My formula is: if PreviousIsNull({F57041.Q1TDTE}) then 0 else datediff('s', Previous({F57041.Q1TDTE}),{F57041.Q1TDTE}) which creates a column of values (seconds). I need to get the sum of seconds but am not sure how to on a formula field. Assistance is greatly appreciated.
  20. kwj1027

    calculating difference from total in previous row

    Amazing how a typo can mess one up! That seems to do exactly what I need. Thank you for your assistance! Regards~ Kevin

Part and Inventory Search

Back
Top