Contents tagged with Reporting Services (SSRS)
-
Configuring SQL Server Reporting Services (SSRS) Users
A few months back, I wrote a post that demonstrated how to access SQL Server Reporting Services (SSRS) reports with the SSRS SDK for PHP. There have been many comments on that post, many of which indicated that people have struggled to get users set up with the correct permissions to access reports. Given the steps that are required to correctly configure users and permissions, I thought video might be a better medium than text for explaining. This video assumes that you’ve gone through the steps in Getting Started with SQL Server Reporting Services to install and configure Reporting Services and to deploy a report. If you’ve done that were then denied access to a report when running your PHP code, this video might help. I’d certainly be interested to if is does help and what other short videos might also be helpful.
-
Rendering SQL Server Reports as Excel Documents with PHP
I wrote a post a while back about getting started with SQL Server Reporting Services (SSRS) and PHP that has generated lots of questions (both in the comments and in e-mail and conversations I’ve had since then). One of the most common questions has been “How do I render a report as an Excel document?” I’ve been telling folks that this is easy with the SSRS SDK for PHP (and it is easy), but when I sat down to do it, I ran into a problem. So, in this post, I’ll show you how to render a SSRS report as an Excel document and how to avoid the one problem that caused me headaches. I will assume you have read my previous post about getting started with SSRS and PHP.