OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Interactive Report and Excel (Apex 3.1 - Unix Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 1589 times)

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Re: Interactive Report and Excel [message #344066 is a reply to message #343952]

Thu, 28 August 2008 12:56

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

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

Report message to a moderator

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

Report message to a moderator

Re: Interactive Report and Excel [message #344659 is a reply to message #344495]

Sun, 31 August 2008 14:23

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

Report message to a moderator

Re: Interactive Report and Excel [message #350356 is a reply to message #344659]

Wed, 24 September 2008 16:58

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?

Report message to a moderator

Re: Interactive Report and Excel [message #350450 is a reply to message #350356]

Thu, 25 September 2008 01:59

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

Report message to a moderator

Re: Interactive Report and Excel [message #350491 is a reply to message #350450]

Thu, 25 September 2008 03:47

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 07 15:16:20 CDT 2025