SSRS report - parameters to convert to datasets

mark goldin 691 Reputation points
2022-01-17T15:14:32.557+00:00

If I send a parameter to a report as either xml ot json string how can I convert such a parameter into a dataset?

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,793 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-01-18T07:37:34.703+00:00

    Hi markgoldin-3750,
    Please check the following articles which might be helpful:
    SQL Server Reporting Services XML Data Source and Data Set
    XML Query Syntax for XML Report Data (SSRS)
    Using JSON as a data source for a SQL Server Reporting Services report
    How to use JSON data in SSRS

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. mark goldin 691 Reputation points
    2022-01-18T12:20:52.53+00:00

    One thing. I need to inject JSON into a report. Is a report parameter a good candidate for this? Are there any limitations on a size of a report parameter when I do a POST to the report URL?

    Thanks

    0 comments No comments