View SSRS reports in ERPNext

1

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

2

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.

3

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

4

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

5

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
6

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?

7

Well, for this kind of reporting try Frappe Insights

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

8

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
9

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

10

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

11

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