none
SSRS 2016 - Mobile Reports available to Customers RRS feed

  • Question

  • We are looking at the possibility of making mobile reports available for our customers to view on our MVC ASP.NET website. <o:p></o:p>

    It appears that traditional .rdl files can be made available to customers by using the ReportViewer windows form class and passing in a Customer ID as a parameter.<o:p></o:p>

    Mobile reports do not appear to be supported by the Report Viewer and all of the solutions I have been able to find have suggested using an iframe and the modified URL of the report.  It appears that this method does not allow one to pass a parameter to the report.  <o:p></o:p>

    We have a large number of customers, so we would like to avoid having to create individual datasets and reports for each customer.  Our datasets are based on SSAS Tabular Models.

    Has anyone made mobile reports available to customers?  If so how have you done so?<o:p></o:p>


    Thursday, July 28, 2016 2:39 PM

Answers

  • Hi Daniel J L,

    According to your description, you want to pass a parameter as CustomerID for mobile report. And make the report only show the corresponding data to current customer. Right?

    To achieve this requirement, you should first ensure that in your dataset there exists a filed which be mapped for the parameter CustomerID. Then you can give this parameter a default value by using Reporting Service built-in function as: =User!UserID. Or you can add a filter instead of adding a parameter. Also give its value by using the built-in UserID fuction. Then use this shared dataset to create a mobile report, publish it to Reporting Service Web Portal. When the customers visit this report, it will retrieve their ID automatically.

    Please refer to following sample: You can choose Set Options to specify Parameters or Filters.

    If you still have any questions, please feel free to ask.
    Thanks,
    Xi Jin.

    Friday, July 29, 2016 10:09 AM
    Moderator