Search results

I am attempting to extract a substring from an external file. I have an external .txt file which contains records of different lengths and type on each line. I import each line of the text file into a temporary table. Each line of text may be up to 200 characters long. I then use a FOR EACH...

Is there any way to sort by a calculated field other then creating temp-tables? I have a report that calculates Days Open, but only does this right before teh DISPLAY block. They want the report sorted by Days Open. With all of the toalling and summarizing going on in the report, I am afraid...

I am having problems with a report in that it is not hitting the IF statements based on the BREAK BY statements in teh FOR EACH block. Examples below. I am creating a report and my main FOR EACH block looks like the following: FOR EACH wo_mstr USE-INDEX wo_nbr NO-LOCK WHERE (wo_site >=...

I am trying to validate the input of a field during the UPDATE block. I have a simple date range and I want to make sure that the second date entered is greater than the first date entered. I have the followign code in place for the UPDATE, but it is not passing validation no matter what dates...

I am working on a custom report that prompts the user for a range of locations, range of departments, allows the user to enter a list of "Hot" parts, a range of dates, etc. My prblem is that if the user blanks the parts list parameter out, I would like the report to find all the parts matching...

I am trying to use dynamic COLUMN-LABEL values. I have a report that displays values for the previous 6 months of the year. I would like to do this dynamically. I would like to figure out what month is to be displayed and use a variable in the COLUMN-LABEL tag instead of hard-coding the...

First time poster. I have a custom report which will be exported to an external text file. I have 31+ columns and am running into an issue with the WIDTH phrase. I set output to the external file and use the DISPLAY command to write to the file. I do not want teh report to wrap because it...