Post reply

SSRS export report as JSON

  • April 4, 2024 at 7:22 pm

    #4407569

    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.

  • April 5, 2024 at 6:16 pm

    #4407981

    Why SSRS? Do you need user interaction?

    If you don't need user interaction then there are better ways to do this. SSRS is for creating formatted output so I am not too surprised there are issues with creating a json file.

  • April 5, 2024 at 6:48 pm

    #4407986

    Our users utilize SSRS to get data now via Excel or CSV.  Just making sure we weren't missing some option to do JSON export in some fashion too.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply