Home » Developer & Programmer » Application Express & MOD_PLSQL » Interactive Report and Excel (Apex 3.1 - Unix Server)
Interactive Report and Excel [message #343213] Tue, 26 August 2008 11:36 Go to next message
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 173 times)
Re: Interactive Report and Excel [message #343404 is a reply to message #343213] Wed, 27 August 2008 03:57 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #344066 is a reply to message #343952] Thu, 28 August 2008 12:56 Go to previous messageGo to next message
rpenna
Messages: 7
Registered: August 2008
Junior Member
Hi everybody,
little update.

I've just installed patch 'p7032837_11106_GENERIC.zip' from metalink.
Now my Apex version is 3.1.1.00.09 (db is 10.2.0.1), but still i cannot see XLS and RTF download format options for the Interactive Report.

Also, i visited the online demo for Apex: http://apex.oracle.com/pls/otn/f?p=22359, where you can see an example of what i mean....

Please help....

Thanks

[Updated on: Thu, 28 August 2008 12:56]

Report message to a moderator

Re: Interactive Report and Excel [message #344343 is a reply to message #344066] Fri, 29 August 2008 07:57 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Interactive Report and Excel [message #344659 is a reply to message #344495] Sun, 31 August 2008 14:23 Go to previous messageGo to next message
rpenna
Messages: 7
Registered: August 2008
Junior Member
dr.s.raghunathan wrote on Sat, 30 August 2008 08:13
hi,

when you get some sort of suggestions on this aspect please pass it to me too.



You too.... Wink

Roberto
icon9.gif  Re: Interactive Report and Excel [message #350356 is a reply to message #344659] Wed, 24 September 2008 16:58 Go to previous messageGo to next message
mlengua
Messages: 1
Registered: September 2008
Junior Member
hi Roberto,
I'm the same problem.
My instalation is apex 3.1.2.00.02 and the db is 10.2.1.0. in windows.

any suggestion?
Re: Interactive Report and Excel [message #350450 is a reply to message #350356] Thu, 25 September 2008 01:59 Go to previous messageGo to next message
andi_raj
Messages: 55
Registered: February 2008
Member
Inorder to get a report in xls or rtf or pdf or xlo format you need to have BI Publisher.
raj
Re: Interactive Report and Excel [message #350491 is a reply to message #350450] Thu, 25 September 2008 03:47 Go to previous message
rpenna
Messages: 7
Registered: August 2008
Junior Member
andi_raj wrote on Thu, 25 September 2008 08:59
Inorder to get a report in xls or rtf or pdf or xlo format you need to have BI Publisher.
raj


Yes, it's true.

I wonder if Apex Developer Team could integrate the solution made by Denes Kubicek (http://htmldb.oracle.com/pls/otn/f?p=31517:108:979050666792099) in Interactive Report.

This works fine with normal report!

Roberto

[Updated on: Thu, 25 September 2008 04:19]

Report message to a moderator

Previous Topic: Bind variables empty
Next Topic: Reg. Mail Sending
Goto Forum:
  


Current Time: Tue Sep 16 17:30:36 CDT 2014

Total time taken to generate the page: 0.09399 seconds