Answered by:
Mobile Reports REST API or report viewer

Question
-
I have an ASP.NET web forms application that needs to embed SQL 2016 mobile reports, but the rs:Embed=true and iframing approach will not work since this is a publicly facing web application and reporting services is installed within my network. Also there are security concerns that querystring parameters could be modified even if I could get my reporting services reports publicly accessible (i.e. querystring variable values within the iframe could manually be changed by any user to view data they should not be able to see). We currently use paginated reports and the report viewer control which proxies the authentication and allows us to control what report data each logged in user can see by passing parameter values in code behind. We really want to be able to start using the new mobile reports presentation but these implementation constraints are preventing us from using mobile reports. Are there any updates on the ability to embed mobile reports using the report viewer or providing a mobile reports REST API? Either of these options would allow us to move forward with mobile reports. I am hopeful that with SQL 2016 SP2 this functionality will become available. There has been some discussion in the comments on these below posts on a mobile reports REST API coming available at some point:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/12/06/whats-new-in-mobile-reports-in-sql-server-2016-sp1/
https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/04/25/new-mobile-report-publisher-preview-now-available/
Also this post mentions allowing the report viewer or a custom authentication support for mobile reports may be coming soon:
https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/11/30/report-viewer-2016-control-update-now-available/Wednesday, June 28, 2017 4:49 PM
Answers
-
Hi Addams-E,
Thank you for your sharing. As you know, currently embedding mobile reports using the report viewer is not supported. Also, the mobile reports will use REST API but it is not available at present. The first two links you provide clarify the use of REST API for SSRS mobile report in the future release. Referring to the third link, "The existing Report Viewer control was designed for ASP.NET Web Forms and for paginated reports. We’ve invested in updating the control to support customers’ existing ASP.NET Web Forms apps, but we don’t plan to extend this particular control to support mobile reports or Power BI reports. " as per my understanding, it is not planned to use report viewer control for mobile report, also, "Unfortunately, this isn’t supported in mobile reports at this time. We’d like to add custom authentication support for mobile reports in a future release." custom authentication for mobile reports could be the possible feature.
However, there seems no clue regarding the very specific schedule regarding these features you mentioned, personally, I recommend you that submit this suggestion at https://connect.microsoft.com/SQLServer/ . If the suggestion mentioned by customers for many times, the product team may consider to improve it in the later SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Also, you could pay attention to the SSRS team blog, which will provide the latest update on the product.
Best Regards,
Henry
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Marked as answer by Addams-E Friday, June 30, 2017 12:43 PM
Thursday, June 29, 2017 7:08 AM -
Thank you for the feedback Henry. I have created a suggestion on the connect website:
https://connect.microsoft.com/SQLServer/feedback/details/3136721
Also I am actively following the SSRS team blog and am hopeful the REST API for mobile reports will come with SQL 2016 SP2.
- Proposed as answer by Henry Jiang Friday, June 30, 2017 1:13 AM
- Marked as answer by Addams-E Friday, June 30, 2017 12:43 PM
Thursday, June 29, 2017 3:30 PM
All replies
-
Hi Addams-E,
Thank you for your sharing. As you know, currently embedding mobile reports using the report viewer is not supported. Also, the mobile reports will use REST API but it is not available at present. The first two links you provide clarify the use of REST API for SSRS mobile report in the future release. Referring to the third link, "The existing Report Viewer control was designed for ASP.NET Web Forms and for paginated reports. We’ve invested in updating the control to support customers’ existing ASP.NET Web Forms apps, but we don’t plan to extend this particular control to support mobile reports or Power BI reports. " as per my understanding, it is not planned to use report viewer control for mobile report, also, "Unfortunately, this isn’t supported in mobile reports at this time. We’d like to add custom authentication support for mobile reports in a future release." custom authentication for mobile reports could be the possible feature.
However, there seems no clue regarding the very specific schedule regarding these features you mentioned, personally, I recommend you that submit this suggestion at https://connect.microsoft.com/SQLServer/ . If the suggestion mentioned by customers for many times, the product team may consider to improve it in the later SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Also, you could pay attention to the SSRS team blog, which will provide the latest update on the product.
Best Regards,
Henry
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Marked as answer by Addams-E Friday, June 30, 2017 12:43 PM
Thursday, June 29, 2017 7:08 AM -
Thank you for the feedback Henry. I have created a suggestion on the connect website:
https://connect.microsoft.com/SQLServer/feedback/details/3136721
Also I am actively following the SSRS team blog and am hopeful the REST API for mobile reports will come with SQL 2016 SP2.
- Proposed as answer by Henry Jiang Friday, June 30, 2017 1:13 AM
- Marked as answer by Addams-E Friday, June 30, 2017 12:43 PM
Thursday, June 29, 2017 3:30 PM -
Hi,
How to solve this issue?
Any news?
Thanks.
Monday, April 16, 2018 4:06 PM