locked
Using GetItemParameters to determine control type. RRS feed

  • Question

  • User-331009151 posted

    Hi all, I am building an MVC / Web API site that has been suitable for many platforms. Part of the app uses SSRS for reporting. I cannot,, and wouldn't want to, use the regular ReportViewer control so I am using the SSRS SOAP clients to get a reports parameter definitions and applicable query based data. With this data I will be building a custom report viewer UI from this parameter data. What I cant quite figure out is how to work if a parameter field is a text input only field, dropdown list, multi-select dropdown list or a date/calendar input. However the date one is quite easy I suppose by looking at the data type. I am assuming that I need to check for a multiple combination of properties but not sure what that combination is, can anyone help?

    Thursday, May 26, 2016 1:38 PM

Answers

  • User-219423983 posted

    Hi scout7,

    I am using the SSRS SOAP clients to get a reports parameter definitions and applicable query based data.

    What I cant quite figure out is how to work if a parameter field is a text input only field, dropdown list, multi-select dropdown list or a date/calendar input. However the date one is quite easy I suppose by looking at the data type. I am assuming that I need to check for a multiple combination of properties but not sure what that combination is, can anyone help?

    If you want to use the SSRS SOAP to render the SSRS report programmatically, it’s better for you to have a look at below links to learn how to build them. In your need, you could get the parameters from your MVC/API project and make the render format be “MHTML”.  Besides, this blog provides the same things about passing parameters to SSRS SOAP and you could also refer to.

    http://www.codeproject.com/Articles/9161/SQL-Reporting-Services-Viewer-Page-Using-SOAP-API

    https://www.experts-exchange.com/questions/27581973/Programmatically-export-an-SSRS-report-to-pdf-file.html

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 27, 2016 6:59 AM