SSRS export report as JSON

[how2trainyourdragon]

We are using SQL Server Management studio to develop a stored procedure that outputs data to JSON via "FOR JSON PATH"

The issue we have is trying to use SSRS to utilize this SPROC and have the data exported as a .json file.
Any way to do this via SSRS?

Currently we are trying table or textbox to display the data, but output gets truncated and doesn't keep formatting/special characters for a valid json file.

 

[PeterDimitrov]

Why do you need SSRS to do this ? SSRS is a presentation layer. You can use SQL Server job to run the stored procedure