Is it possible to create SSRS reports inside a react application?

1
votes

As the title reads, I'm trying to figure out how I would implement SSRS reporting inside a ReactJS application. Does anyone know how to achieve this?

I've looked into embedding Power BI reports into my React application, however I would prefer to use SSRS as it is free (I'm using SQL Server).

My current approach is to gather the reporting service data from the client (filters, report type, etc.), build the report from the server side, then send the report to the client as a pdf. I would much rather integrate SSRS into my application if possible however.

Edit

I'm aware of Power-BI, however I would prefer to use SSRS as it is free with my edition of SQL Server.

1
reactjsreporting-services
have you tried github.com/Microsoft/PowerBI-React ? – Mini
No I haven't, thank you for pointing this out to me. – MEnf
@Mini it would appear that the project has not been fully integrated to work with react. It also does not show up in npm as documented in one of their issues shown here github.com/Microsoft/PowerBI-React/issues/5 – MEnf

1 Answers

3
votes

The easiest integration for SSRS is using the URL Access API. You can generate a URL that calls your SSRS Report Server passing report parameter values and output format parameters. I'm no expert in React but the integration of a URL should be easy for any web dev tool/framework.

It assumes you already have a working SSRS server with reports published to it - this is a useful step anyway for testing/debugging.

Here's the best starting point for the SSRS URL Access API doco:

https://docs.microsoft.com/en-us/sql/reporting-services/url-access-ssrs?view=sql-server-2017