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.
Does anyone have any suggestions preferably open source.
ASKER
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.
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...
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...
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.
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.
ASKER
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.
Well, I found a semi-recent article here which lists 5 different free, open-source reporting applications. Might get you started...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BIRT is a java reporting go-to, but there's some movement on the .Net front:
Net-Birt.html
Net-Birt.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.