Device information settings in SSRS are used to pass parameters to a rendering extension. For more information regarding device information settings in reporting services, see Passing Device Information Settings to Rendering Extensions.
For SQL Reporting, none of the options specified in the above article are feasible. We see a lot of scenarios where we would want to modify these settings, and render/export the report in the format that we are looking for.
For SQL Reporting reports, we can explore the SOAP APIs in modifying these device information settings at the run time. If we have integrated SQL Reporting within our applications, this approach is really easy, by just creating a separate function.
Here are some steps to achieve this:
- Generate the proxy class for ReportExecution2005.asmx.
- In the browser, go to the path for your endpoint. For example: https://<INSTANCE_NAME>.report.int.mscds.com/ReportServer/ReportExecution2005.asmx
- If prompted for credentials, type your SQL Reporting username and password and click Sign In. A WSDL file will be displayed in the browser.
- Open the Visual Studio Command Prompt and run the wsdl.exe command to generate the proxy class. For example: wsdl /language:CS /n:”ReportExecution2005″ https://<INSTANCE_NAME>.report.int.mscds.com/ReportServer/ReportExecution2005.asmx
For more information about unsupported APIs in SQL Reporting, see http://msdn.microsoft.com/en-us/library/windowsazure/gg430132#UnsupportedAPIs
- Windows Azure SQL Reporting for Application developers
- SQL Reporting Samples
- Windows Azure SQL Reporting
Any questions around this, feel free to ping me.