If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Database report presentation

irishguy · 2008-10-31 17:36:11

Does anyone know of an open source tool that will allow me to run automated reports on a database and present the results in html format. I would be useful if it had graphing tools etc

Options

31-10-2008 6:36pm

#1

irishguy

Registered Users Posts: 3,299 ✭✭✭

Join Date: June 2001

Posts: 2602

Does anyone know of an open source tool that will allow me to run automated reports on a database and present the results in html format. I would be useful if it had graphing tools etc

0

Comments

Options
#2 31-10-2008 7:33pm
Evil Phil

Registered Users Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

Not off hand but don't forget the Open Source forum too.

0
Options
#3 31-10-2008 8:52pm
NeverSayDie

Registered Users Posts: 515 ✭✭✭

Join Date: July 2002

Posts: 419

Did a Google or two and came across this crew;
http://reporting.pentaho.org/report_designer.php

There were some news stories about them doing a reporting component for OpenOffice, don't know what came of that, but their software sounds interesting anyway, could be worth a look.

0
Options
#4 31-10-2008 10:45pm
Webmonkey

Registered Users Posts: 9,579 ✭✭✭

Join Date: March 2003

Posts: 9397

Worked a bit on BIRT over the summer. It can be integrated into website also if you have the BIRT Viewer installed on your PC.

http://www.eclipse.org/birt/phoenix/

0
Options
#5 01-11-2008 2:01pm
irishguy

Registered Users Posts: 3,299 ✭✭✭

Join Date: June 2001

Posts: 2602

Webmonkey wrote: »

Worked a bit on BIRT over the summer. It can be integrated into website also if you have the BIRT Viewer installed on your PC.

http://www.eclipse.org/birt/phoenix/

Thanks. Both applications look pretty cool, but I need something like that where I can design a report template and then it will be generated on a monthly/weekly basis. Not sure if these tools do that.

0
Options
#6 01-11-2008 2:02pm
Webmonkey

Registered Users Posts: 9,579 ✭✭✭

Join Date: March 2003

Posts: 9397

irishguy wrote: »

Thanks. Both applications look pretty cool, but I need something like that where I can design a report template and then it will be generated on a monthly/weekly basis. Not sure if these tools do that.

Well BIRT is live as in everytime you connect it gives you the actual status. Don't know if that what you looking for though.

0
Advertisement
Options
#7 01-11-2008 2:15pm
irishguy

Registered Users Posts: 3,299 ✭✭✭

Join Date: June 2001

Posts: 2602

Yes this might do the trick then. Ill download it and have a poke around thanks.

0
Options
#8 04-11-2008 5:18pm
John_Mc

Registered Users Posts: 2,791 ✭✭✭

Join Date: May 2005

Posts: 2516

What type of database? MS SQL Server 2005 comes with Reporting services which allows you define a report against values in a DB.

Comes free with the server license IIRC

0
Options
#9 04-11-2008 5:23pm
i71jskz5xu42pb

Closed Accounts Posts: 1,806 ✭✭✭

Join Date: October 2003

Posts: 1683

http://jasperforge.org/

0
Options
#10 04-11-2008 6:55pm
irishguy

Registered Users Posts: 3,299 ✭✭✭

Join Date: June 2001

Posts: 2602

Its MSSQL 2005 server all right, i must take a look at it wasnt aware that there was one included. Thanks

0
Options
#11 04-11-2008 11:19pm
John_Mc

Registered Users Posts: 2,791 ✭✭✭

Join Date: May 2005

Posts: 2516

irishguy wrote: »

Its MSSQL 2005 server all right, i must take a look at it wasnt aware that there was one included. Thanks

Yeah it's pretty handy alright. You can also create report models so that end users can create their own reports, without knowledge of the underlying schema. Although this is a bit limited in the amount of joins it may do, it's pretty handy.

0
Advertisement
Options
#12 07-11-2008 5:22pm
stevenmu

Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭

Join Date: July 2003

Posts: 9396

You can also schedule reports (or end users can subscribe to them on their own terms), so if when you create your report you can set it to mail out to people every week/month etc.

It's not open source, but if you already have SQL Server 2005 it is free if that's what you were going for. Very good features and very simple to use.

0