View SSRS reports in ERPNext

Is it possible to view SSRS (SQL Server Reporting Service) reports in ERPNext?

We are getting data from SQL Server but it is a long road. ODBC Drivers and settings should be ok. Which version of SQL Server are you using? SQL 2014 was painfull.

I think @farukahmmed is talking about RDL or RDLC reports. Right? I never seen anything related in ERPNext/Frappe …

yes, you are right, I am talking about rdl.
ErpNext is lack of good report bulder.
I need to design some complex reports.

I use Metabase for that. I strongly suggest you to evaluate it a little bit. Most probably in 15 minutes you will see dashboards :slight_smile:

2 Likes

Metabase is also good. but can you open/view the Metabase report from Erpnext as like as buitin report. Or you need to login to metabse than view the report?

Well, for this kind of reporting try Frappe Insights

GitHub - frappe/insights: Free and Open Source Data Analytics Tool for your Frappe Apps

I have invented a trick to open SSRS (.rdl) report from erpnext.
I have create an empty DocType and type some JavaSctipt code to open SSRS report in popup window.

1 Like

Frappe Insights has been released few months ago. It is not matured enough as SSRS.

Can you share this? Could be useful for other users (like me :nerd_face:)

The trick is very simple.
in docktype JavaScript refresh event type window.open(“url of ssrs report”)

Example:
frappe.ui.form.on(‘Leave Application Report’, {
refresh: function(frm) {
window.open(“http://ssrs-server-ip:port-number/ssrs-report-url”, “_blank”, “directories=no,titlebar=no,toolbar=no,location=no,status=no,menubar=no,scrollbars=no,resizable=no,width=1200,height=550”);

 }
1 Like