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.
dreamer123456Asked:
Who is Participating?
 
Aaron TomoskySD-WAN SimplifiedCommented:
Power BI works very well for more technical users to create, easy to distribute to non-technical users.
1
 
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.
2
 
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.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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...
1
 
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.
1
 
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.
0
 
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...
0
 
Michael FowlerSolutions ConsultantCommented:
You could always look at JasperReporting
0
 
Russell FoxDatabase DeveloperCommented:
BIRT is a java reporting go-to, but there's some movement on the .Net front:
Net-Birt.html
0
 
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.