Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Alternative SSRS Front-ends [closed]

Given that Sql Server Reporting Services is designed to be open and extendable, and that the bundled Report Manager isn't that great, are there any alternative open-source SSRS Front-ends out there?

By 'front-ends' I guess I mean web apps that can display the available reports on the reports server, gather the required parameters (hopefully in a more flexible way than Report Manager) and then run the reports. I'm imagining things that are built using the Asp.Net ReportViewer component, but have better parameter gathering.

I've found one on CodePlex: reportviewer.codeplex.com (edit: actually, this looks like a winforms solution, but its the closest I've found) ... but I'm wondering if there are others out there, cos this seems like an area in which lots of people have had to 'roll their own'.

like image 620
codeulike Avatar asked Mar 11 '11 12:03

codeulike


People also ask

What is the replacement for SSRS?

Power BI Report Server (PBIRS) is the successor of SSRS and has more features than SSRS. For one, it can use and render both interactive PBIX and analytical XLSX reports which SSRS cannot. PBI now has Cortana integrated for AI-based natural language, Q&A about your data and reports in Power BI.

Does Microsoft still support SSRS?

What's new in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn. This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

What are different modes in SSRS?

A Reporting Services report server runs in one of two deployment modes; Native mode or SharePoint mode.

How do I deploy SSRS reports in SharePoint Integrated mode?

In Solution Explorer, right-click the report you want to publish, and click Deploy.


1 Answers

To answer my own question: There didn't seem to be any alternative open-source SSRS Front-ends out there, so I have built one and open-sourced it:

CrissCross at Github

You point it at your SSRS server and then off it goes - it can display the report catalogue and lets users run any report. So far I've optimised it towards reports with lots of optional parameters and lots of multi-picks, but it should be able to handle any SSRS report. And if it can't, you can get stuck into the code and change it.

The main difference to the standard SSRS Report Manager is in the presentation of parameters: CrissCross is more ajaxy, and (being open-source) more customisable.

See the github site for more details.

like image 81
codeulike Avatar answered Oct 14 '22 07:10

codeulike