Discussion Locked

Web reporting from dB

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

ToughChoices,

Design phase:
The boss wants access across Web:
1. Drill down reporting on tables of numbers
ie. view 1 - sales per quarter
ie. view 1.1 - sales per month
ie. view 1.3 - sales per week
2. Graphical plotting ofthe numbers
3. User configurable webpages
4. Adminstrative webpage display
5. 50 users max (for meetings)
6. db size(static images means huge)
7. updated once per week (1 year till archive)

I am looking into seagates-CrystalReports, hyperions-enterprise reporting and business objects - webintelligence. SAP datawarehouse was tried (totally non-functional), so the boss is now thinking about getting some tools. I'm inclined towards linux-APACHE-PHP-PostreSQL (with scripts generating the dynamic images).

My question then is:
Criticise the above apps and tools or suggest other reporting tools

If a couple of people have great answers I'll repost to give points.

Jesper

4 replies

by pierce9

I think Crystal Reports is very powerfull and the company has come a long way since the beginning. Earlier products were a little rough but the latest version of the web server software is really good. Great drill down capability and ease of use.Another suggestion to try is a new package called Actuate. Check into it a www.actuate.com. Good Luck

by pierce9

Oops I didn't see the post comment option on this....didn't mean to post that as a definite answer...Sorry

This discussion is closed to new replies.