locked
Build report from JSON data RRS feed

  • Question

  • Hello,

    I need a way to build SSRS report, where datasource would be [JSON].

    We are building stateful microservices, and our data exists in service itself. Currently we access or post data in JSON format to the service.

    Thursday, February 22, 2018 5:08 AM

Answers

  • So you use local Rendering and not Reporting Services? In that case you can pass any kind of IEnumerable class as data source, as you already do.

    In .NET we have also a JsonDeSerializer to convert JSON string into classes with list/collections which can be used as data source.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Thursday, February 22, 2018 9:18 AM

All replies

  • Hello,

    Currently JSON is not supported as data source by Report Builder / Report Server, see Data Sources Supported by Reporting Services (SSRS)

    But you can consume XML returned from web services, see Reporting Services: Using XML and Web Service Data Sources


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, February 22, 2018 6:44 AM
  • Hello Olaf,

    Thanks for guiding.

    What we did is, we built the report using XML data source.

    But while calling the report from UX/ViewModel in WPF application, we binded the report thru observable collection and it gives correct result.

    reportDataSource = new ReportDataSource("DS_"+ reportName, reportData);

    _reportViewer.LocalReport.DataSources.Add(reportDataSource);

    I would like to take your feedback, if we are doing right way or not?

    Best Regards, Ajay


    Thursday, February 22, 2018 7:10 AM
  • So you use local Rendering and not Reporting Services? In that case you can pass any kind of IEnumerable class as data source, as you already do.

    In .NET we have also a JsonDeSerializer to convert JSON string into classes with list/collections which can be used as data source.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Thursday, February 22, 2018 9:18 AM