Export to EXCEL

[sniru9]

Hi List,


I need to export a report to Excel.Is there any method other than .CSV option.
.CSV is not aligning properly.

I appreciate your quick response.

Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i

 

[cblackwell]

Try the database output option in RDA. It's listed under 'Section'.

 

[sniru9]

Re: RE: Export to EXCEL

Hi There,

Do I need to create a file in Excel with the same format and save it in B7/PrintQueue.Any suggestions????



Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i

 

[sviardot]

Another possibilities is to make a specific developement for a ube using a
database output to a text file. You shoud use a comma separated text file
then you could easely pen such file with excel.
----- Original Message -----
From: "sniru9" <[email protected]>
To: <[email protected]>
Sent: Tuesday, April 24, 2001 8:03 PM
Subject: Export to EXCEL


option.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=9713

 

[gezquerra]

Hi!

To revolve some problems with csv export, try to find in "SAR Search" the
document number "ott-00-0047". This is a how to, that explain some tips,
i.e. : Setting "Horizontal grid spacing" to 52 in the layout menu of the
RDA.

Gilbert
OneWorld B7332 SP 11.3
AS400



-----Mensaje original-----
De: [email protected] [mailto[email protected]]En
nombre de sniru9
Enviado el: martes, 24 de abril de 2001 20:04
Para: [email protected]
Asunto: Export to EXCEL


Hi List,


I need to export a report to Excel.Is there any method other than .CSV
option.
.CSV is not aligning properly.

I appreciate your quick response.

Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=9713

 

[sniru9]

Re: RE: Export to EXCEL

Hi James,Chandu,Gilbert


Now am able to export the report to EXCEL without overlapping and blank columns,
with the help of your suggestion and JDE Knowledge Garden document.

Thanks again for your quick response.


Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i

 

[sniru9]

Re: RE: Export to EXCEL

Hi List,

The following steps will help in exporting the report to EXCEL

1.Created new version for EXCEL(for PDF I am using different version to overcome shrinking data problem)
2.Go to Report Design
3.Go to Layout/Grid align ment and change the Horizontal spacing to 52
Make sure that options Display Grid and Snap to Grid were checked and click OK
4.Dotted lines will appear on report
5.Adjust the fields by dragging it to fit in between dotted lines
6.Make sure that each colums or variable right adjusted(to appear cleanly and avoid overlapping)
7.Run the report by choosing the report destination option as Export to CSV radio button
8.We will see a clean report in EXCEL(we can drag the cells to see the hidden stuff)


Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i

 

[arrozpegao]

Re: RE: Export to EXCEL

there another way for export to excel.
Open Flat File
Write One Line To Flat File
Close Flat File
B34A1010 function

you must equal one variable to a strig list, something like this:


VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode2]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode3]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode4]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode5]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode6]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode7]))
VA rpt_Linea = concat([VA rpt_Linea],concat('$',[VA sec_SalesReportingCode9]))

then you put the 3 business functions
and you have a file wich can you open with excel. the use the text in columns function and it is.

in this case i use $ delimiter


if have any question you can send me a mail and i answer you.

pd: sorry for my english ;D