[RBG7-L] - Re: GATEWAY question

[David M. Blocker]

Javier   WAY back in July of 03 I submitted this enhancement request:   ENHANCEMENT REQUEST:  Add �OPTION� syntaxes for GATEWAY command to XLS format to match Menu options:  Add in these options: *    �zeros as blank vs. zeros as zeros� *    blank row after field names (yes/no) *    Custom caption, alighnment, background, font and width for each column *    Custom header and footer   This is not exactly the same as what you are describing, but it is related.  I checked the status of this request today and found that this number is not being tracked any more.  However, I don't see any options like this in the help screen for GATEWAY.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Javier Valencia To: RBG7-L Mailing List Sent: Thursday, February 10, 2005 7:51 PM Subject: [RBG7-L] - GATEWAY question I am using the following command: GATEWAY EXPORT xlsw �test.xls� SELECT labor_date,labor_hr_reg,labor_hr_ot,labor_hr_2times,labor_hr_all + FROM temp_graph1 OPTION col_names ON |tab_name tab01 |show_progress ON |action openview   Some of the cell in the R:Base table have a value of 0; the export works fine except that all the cells that have a 0 value show up in the spreadsheet as blanks, I have used the XLS option with similar results. If I use the Gateway Icon on the top menu and do the same thing, the values export correctly and show up in the spreadsheet as 0 rather that blanks�is there and option that I am missing??? TIA. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================