Search results

do you know how I can rename the new worksheet?

I need to add another sheet to an existing excel workbook. I have a temp table that needs to be dumped to a new sheet in a workbook, rename the sheet, and then exit. I use the following code to create a new excel document but I'm not sure how to open an existing one and work on that. DEF VAR...

Is there a way to do a bi-level break by statement? I need to do the following: Break all orders by the sales person that took them --> Break those blocks up by order number to gather data. I'm trying to run a daily sales report that takes the total orders/salesperson as well as their total...

Our company runs our database off of Progress 9.1 and we own a website that is run remotely off of a SQL server. What I would like to do is query information from our Progress database and push the value to a matching record in the SQL database. For Example: Find Customers with Credit Terms -->...

Thank you!

Hi, I'm stuck trying to find descriptions containing the strand "-OBS" from our database. I have done it before I just forgot how. Here is what I have: FOR EACH ITEM WHERE ITEM.stat = "O" AND ITEM.DESCRIPTION = "*-OBS*": DISPLAY ITEM.ITEM. END. This isn't returning the values I am...

I ran an export with it and what it does is it runs off the order number with the first tracknum then it runs off another line with the order number again and two tracknums seperated by the comma and so on. I need just the final value where, if there are 5 tracknums associated with the order, it...

nevermind on the error. discrepancy with table references. thank you for the help

forgot to mention but this will work in progress 9.1 right? throwing me an error on the if first of line

I need to runoff values and group by duplicates to create an htm document. For example, a typical runoff would look like this: Order Number: 5610 Tracking Number: 654654654 Order Number: 5610 Tracking Number: 987987987 Order Number: 5612 Tracking Number: 321321321 (Obviously in spreadsheet...

Hi, I'm still learning Progress and am trying to run an output from our Syteline database. Here is my query that I have: OUTPUT TO l:\test\testfolder\runrate.dat. EXPORT DELIMITER "," "Item" "Description" "Machine Run Rate" "Labor Run Rate" . FOR...

I got it with this code: vchWorksheet:COLUMNS("D:D"):NumberFormat = "@". The single quote worked but it still keeps that as a value in the table. When I push the excel table to our web server it would display the tracking numbers as '########. The above quote formatted it so that it would...

Hi All, I need help with an Excel Export. I'm trying to export a column as text. I need FedEx shipping numbers in the column which have a leading "0" that excel keeps deleting when opened. I used to export as a .dat file, format that column as text, and then save as an excel worksheet. I want to...