web based reporting not a saas

Hello all

I am looking for a solution I can either buy or is open source for web based reporting from our database.  I do not want to licenses a SAAS.

The solution needs to work like crystal reports for the web in allowing the user to run canned reports, create new reports, export to pdf and excel along with creating and modifying templates,
Who is Participating?

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

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.

What is wrong with Crystal Reports or MS SSRS?

I don't know the acronym SAAS.  WHat is that?

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Software as a Service
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

HalCHubAuthor Commented:
what makes you think i am running a windows platform ?
You asked this in the Crystal Reports topic area.

In order to help, we need to know some of the parameters of the system you will be using.
Please provide some information on the target platform if it is selected.  If you haven't selected a platform that would be helpful also.

How many users?
How many simultaneous?

How many potential developers?

How many reports?

What size database?

Are the reports to be scheduled, run on demand or both?

HalCHubAuthor Commented:
You all are loosing sight of the base question
Since you won't give us guidance on your platform.

What is wrong with Crystal Reports?  You say you want it to function like Crystal.

What is wrong with SSRS from MS?

I think you will find that most of the experts in the Crystal and DB Report tools topics are Windows centric and don't have a lot of insight into non-Windows based tools.

HalCHubAuthor Commented:
I am running on Linux or MS I am looking for a solution that would work on both.  that is why the first item is web development.
Crystal and it family of tools can deliver on Linux but the reports must be developed on Windows platforms so it is obviously out as a candidate.  

I believe SSRS has the same limitation.

Have you considered Jasper Reports


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
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
Web Development

From novice to tech pro — start learning today.