dbTalk Databases Forums  

Web.Show_Document to display data in Excel

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Web.Show_Document to display data in Excel in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
papalphaus@yahoo.com
 
Posts: n/a

Default Web.Show_Document to display data in Excel - 11-06-2007 , 04:00 PM






We are using WEB.SHOW_DOCUMENT to display the data from a journal
table in an excel spreadsheet format. Everything shows up good except
some of the columns in the first row of data only, is right justified
instead of left justified like in all the other rows. My select
statement is formatting a date field, which is followed by 2 varchar
fields, then 3 number fields. It is the 3 number fields that are
right justified in the first row only. There is other data after
these 3 number fields and they all are left justified even though some
are number fields and some are varchar fields. If anyone has ever
experienced anything like this, and has a constructive suggestion on
how to correct it, I would greatly appreciate any suggestions. This
is being displayed using an IE7 browser and my Oracle environment is:
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production


Reply With Quote
  #2  
Old   
shakespeare
 
Posts: n/a

Default Re: Web.Show_Document to display data in Excel - 11-07-2007 , 03:21 PM







<papalphaus (AT) yahoo (DOT) com> schreef in bericht
news:1194382806.956246.203530 (AT) 50g2000hsm (DOT) googlegroups.com...
Quote:
We are using WEB.SHOW_DOCUMENT to display the data from a journal
table in an excel spreadsheet format. Everything shows up good except
some of the columns in the first row of data only, is right justified
instead of left justified like in all the other rows. My select
statement is formatting a date field, which is followed by 2 varchar
fields, then 3 number fields. It is the 3 number fields that are
right justified in the first row only. There is other data after
these 3 number fields and they all are left justified even though some
are number fields and some are varchar fields. If anyone has ever
experienced anything like this, and has a constructive suggestion on
how to correct it, I would greatly appreciate any suggestions. This
is being displayed using an IE7 browser and my Oracle environment is:
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production

Try putting an emtpy row on top, or a row with column titles..... a silly
workaround, but it may work.

Shakespeare




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.