| Interactive Report and Excel [message #343213] |
Tue, 26 August 2008 11:36  |
rpenna
Messages: 7
Registered: August 2008
|
Junior Member |
|
|
Hi guys,
i have an application with several interactive reports.
I need a 'download option' vs Excel so interactive report is fine for me!
I cannot use CSV format because Excel delete leading zero in not-numeric fields....
In documentation i saw several downloading format: CSV, PDF, Excel and RTF, but in my installation i find only CSV and PDF.
I can't find how to enable XLS and RTF format for download from interactive report.
I have two Apex installations (same release), on Unix (10g) and Windows (XE).
Anyone could help? In attachment an image showing it.
Thanks in advance.
Roberto
-
Attachment: img.jpg
(Size: 135.89KB, Downloaded 1573 times)
|
|
|
|
| Re: Interactive Report and Excel [message #343404 is a reply to message #343213] |
Wed, 27 August 2008 03:57  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
hi,
technically i can not give solution however what i did and achieved to overcome leading zero's problem while converting csv and xls for downloading can be explained.
I just opened xls file and simply saved as .csv file. and closed it. I have not tested on opening the csv file. Then straightaway through apex import option i pooled data file from csv ( which has been recently saved) through utilities no damage has been happened for leading zeros.
am i nearer to your problem
yours
dr.s.raghunathan
|
|
|
|
| Re: Interactive Report and Excel [message #343497 is a reply to message #343404] |
Wed, 27 August 2008 07:36 |
rpenna
Messages: 7
Registered: August 2008
|
Junior Member |
|
|
Thanks for your reply.
What i need to do is a page with an interactive report and use the tools (as you know) available in it, like download in any format.
This because users want to download the data in Excel for further manipulation.
In my installations I haven't the checkbox for XLS and RTF download formatting.
In Apex manuals (installation and admin guides) i didn't find how to enable this formatting option for download actions, while in developers guide i saw this kind of options.
I'm looking for tips on how enable them.....
Thanks again.
Roberto
|
|
|
|
| Re: Interactive Report and Excel [message #343952 is a reply to message #343497] |
Thu, 28 August 2008 08:55 |
rpenna
Messages: 7
Registered: August 2008
|
Junior Member |
|
|
I found that online documentation is for APEX 3.1.2, but my installation is versione 3.1.0.00.32.
Maybe my problem could be resolved with an upgrade?
In any case, in download page from OTN i see that the last version is 3.1.1, also in metalink i found only version 3.1.1
There is a mistake in documentation?
Excel and RTF download formatting option is only available in this very last version 3.1.2?
Where can i find the 3.1.2?
Thanks.
Roberto
|
|
|
|
|
|
| Re: Interactive Report and Excel [message #344343 is a reply to message #344066] |
Fri, 29 August 2008 07:57 |
rpenna
Messages: 7
Registered: August 2008
|
Junior Member |
|
|
Made upgrade to version 3.1.2 (patch 7313609).
No yet XLS and RTF donwload format options.
But on Oracle Forums i found a 3d telling that we need BI Publisher in order to have those options....
Roberto
|
|
|
|
| Re: Interactive Report and Excel [message #344495 is a reply to message #344343] |
Sat, 30 August 2008 01:13 |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
hi,
i was also waiting will there be any other solution without using BIP. If we can find some option without using BIP then we can some more wonders on reporting like Invoice generation (free format reports ) printing on preprinted stationary etc.
when you get some sort of suggestions on this aspect please pass it to me too.
yours
dr.s.raghunathan
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
