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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TolomirAdministratorCommented:
See this video to get an impression how powerful this free suite is:

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

0
OP_ZaharinCommented:
- 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.