Using R graph in SSRS

example how to use:

https://www.mssqltips.com/sqlservertip/4127/sql-server-2016-r-services-display-r-plots-in-reporting-services/

interact R plot examples:

http://www.rebeccabarter.com/blog/2017-04-20-interactive/

 

Install R service in database:

 

Enable R:

EXEC sp_configureĀ  ‘external scripts enabled’, 1

RECONFIGURE WITH OVERRIDE

install R package from TSQL

https://www.accelebrate.com/library/tutorials/r-add-new-packages

 

install R from command line for SQL SERVER

http://www.sqlservercentral.com/articles/R+Package/145571/

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *