Free Oracle Reporting Tools Excel

Hello Experts,

I am running a project and I need some on advice on any "free" (if any) Oracle reporting tools.

We normally use such products as Lasata or Jet Reports but this customer is completly short of budget.

They demand some reporting from our Database that normally requires some extracting and reporting tools that can export to Excel.

Can you recommended me any free or almost free tool that could provide this functionllity.

Any recommedations are welcome and points will ge given to the best shoot.

Thanks





FABRICIO76Asked:
Who is Participating?
 
TolomirConnect With a Mentor AdministratorCommented:
you can take the free reporting tool from Microstrategy.

this is the full featured suite (lacking some advanced features) with 2 full users and up to 100 r/o users.

http://www.microstrategy.com/freereportingsoftware/

You even get 30 days free support. While the regular version of microstrategy is not that cheap (you can easily shell out 20k on license costs) this special edition is meant for low budget situations, after 30 days support you get community support on their forum.

Just give it a try. Of cause it comes with full excel support.

0
 
johnsoneSenior Oracle DBACommented:
Have you looked at using SQL*Plus?  If your requirement is just getting information into Excel, you should be able to do it with that.

You can create a csv file with something like this:

select col1 || ',' || col2 || ',' || col3
from table;

If you want to put double quotes around character colunmns, just add them in to the concatenation with a comma.

Once the file is created you should be able to open it in Excel.  If you name the file with a .xls extension, Excel should do the conversion behind the scenes and the user never knows the file is not really an Excel format.
0
 
FABRICIO76Author Commented:
Hello,
I am sorry but we are talking of something more advanced.

We are familiar with Oracle and Oracle Reports Builder but when advanced reportings, grapichs are needed even those are limited.

0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
gatorvipCommented:
If all you require is querying the database for data, then you can do that in Excel directly via ODBC or OLE.

Here's an example using Excel 2007 and OLE:

http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/



If you want a nicer interface to the database than SQL Plus, check out Oracle SQL Developer (it's free).
0
 
FABRICIO76Author Commented:
Hello Gatorvip,

We also use frequently those tools but connection directly to excel is very unreliable.

Sql Developer I use daily but not as a reporting tool. Perhaps there is any add in or options we are missing but Sql Developr is not intendeed for reporting creation.

I know I am not asking an easy question, the tools I mentioned do cost money becase thehy are good for it.
0
 
TolomirAdministratorCommented:
See this video to get an impression how powerful this free suite is:

http://www.microstrategy.com/freereportingsoftware/demovideos/overview/

0
 
OP_ZaharinConnect With a Mentor Commented:
- you might want to look into LogiReport. it offers crosstabs, drill-down and drill-through, charting, data grouping, sorting, paging, aggregation and other calculations, export functionality (Excel, Word, CSV, HTML and PDF among others) and many more for FREE:
- it works with SQL Server, Oracle, Sybase, MySQL, DB2, Acces..
 
http://www.freereporting.com/
0
 
FABRICIO76Author Commented:
Thanks a lot both.

I spen so much time looking for similar tools.

You both deserve so many more points!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.