Reporting tools

We have custom .NET web application with sql server database. We need a reporting module integrated for our application. users have suggested having a reporting module where they can select their fields and execute the report.

Does anyone have any suggestions preferably open source.
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.

Jeff EdmundsApplication Developer/SQL DBACommented:
What version of SQL Server are they running? What version of .NET was the application developed in?

Do they already have SQL Server Report Services running on their server? If so, you might be able to use Microsoft Report Viewer controls in your application to display reports.  I've got several .NET applications which display SSRS reports within integrated Report Viewer controls. The reports can either be local or hosted on the SSRS server.

Take a look at this link:  Microsoft Report Viewer 2010 Redistributable Package

It's basically a set of DLL's that you reference in your application to gain access to the Report Viewer control. The same download is installed on the user's machine so they can use the control. Pretty quick and easy.
dreamer123456Author Commented:
SSRS is good solution for canned reports. Users are looking more of custom reports, where they can select the fields from list of fields and execute themselves. I am not sure if this is feasible with SSRS.
Jeff EdmundsApplication Developer/SQL DBACommented:
I don't personally have any experience with any third-party reporting applications that integrate with your .Net code and allow the user to create custom reports.

How pretty does the returned information need to be? Anytime I've needed to do something like that I've built a custom form in the .NET application which queries the tables or views to populate controls on the form with the available field names, then builds a SQL query behind the scenes, executes it against the SQL database and then populates the results in something like a DataGridView control...
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeff EdmundsApplication Developer/SQL DBACommented:
Side note... I have heard of DevExpress products but I have never used them, so I can't endorse them. They are not open source but may have something along the lines of what you're looking for. Might be worth a look.

I generally shy away from including third-party content in my stuff, just because I don't know how long the developers will be around to support and update their components. That's not to say I've never included third-party components - sometimes there's no alternative. It's just not my personal preference.
dreamer123456Author Commented:
I am not looking to necessarily integrate within the application, but I presume there are third party software that will pull data from database and present the reports. As long as they support single sign on  and pull data from sql server we are good to go.
Jeff EdmundsApplication Developer/SQL DBACommented:
Well, I found a semi-recent article here which lists 5 different free, open-source reporting applications. Might get you started...
Aaron TomoskySD-WAN SimplifiedCommented:
Power BI works very well for more technical users to create, easy to distribute to non-technical users.

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
Michael FowlerSolutions ConsultantCommented:
You could always look at JasperReporting
Russell FoxDatabase DeveloperCommented:
BIRT is a java reporting go-to, but there's some movement on the .Net front:
ValentinoVBI ConsultantCommented:
As you've already got SQL Server and the need to integrate is not absolutely required you may want to look into this: Microsoft® SQL Server® 2016 Report Builder

It's a free-to-use and easy tool for users to create reports and once you get to know it a bit better it's actually rather powerful.
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
.NET Programming

From novice to tech pro — start learning today.