Search results for query: *

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

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

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

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

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

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

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

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.

I am calculating the number of seconds since midnight to a date/time in a row. I need to subtract the previous row entry from the current row to determine the amount of time (seconds) between the two rows. Hopefully this is descriptive enough to describe the needed solution. Regards

Trying to put a vbCrLf in a batch file using wscript (example below). When I run the script with the & vbCrLf & it skips that portion and goes to the next step. I have tried several variations for the CrLf to no avail. echo wscript.echo inputbox("Enter the Software Revision you wish to...

Hello, I am trying to import a pick list for use in a drop down box of parameters. That is the easy part, the difficulty I am encountering is that the selections have embedded spaces (required) in front of the selection. When I pull the list in the spaces are removed from the selection. Is...

Good afternoon all and thank you for your time. I have a system where a test process triggers the execution of a batch file that automatically generates an ftp script and subsequently executes and ftp session to 'put' the results of the test on a remote AS/400. Everything works fine, for the...