Getting Started with SQL Server Reporting Services SSRS and PHP Brian Swan. In a recent post I took a look at how to get started with SQL Server Reporting Services SSRS. In this post Ill dive into the SSRS SDK for PHP that was recently released by the Interoperability team here at Microsoft. The SSRS SDK for PHP allows you to render render reports from within your PHP code. The documentation in the SDK is complete with explanations for the classes that make up the SDK, code examples, and a hello world example. However, in this post, Ill build a simple web page code attached to this post that renders the Sales report that I created last week. My example uses some reporting features that arent shown in the hello world example, and this way youve got multiple examples to work from when you want to use the SDK. Edit If you have trouble setting up user permissions with SSRS, this video may be helpful https www. PSYHqkhhd. Oo. Overview. My WAMP server was working absolutely fine yesterday. Today I had to restart my computer and something fouled up the works. The server never fully starts. This tutorial will walk you through setting up a WAMP Server using software that can be found on sourceforge for use. First, a little description is an order. A WAMP. How to Connect to a MySQL Database from PHP. To build a MySQL databasedriven web application in PHP, the very first thing you need to do is connect to a MySQL database. How To Run Php Program In Wamp' title='How To Run Php Program In Wamp' />With the Business Intelligence Development Studio you can design reports in SQL Server 2. Reporting Services. You can access these reports directly via the Report Server as I showed in this post or you can use the SSRS SDK for PHP, which uses the SOAP API to communicate with the SQL Server Reporting Services Web Service. In a recent post I took a look at how to get started with SQL Server Reporting Services SSRS. In this post Ill dive into the SSRS SDK for PHP that was. It says php not recognised as any internal or external command, operable program or batch file. Prerequisites. Follow the steps in this post for creating the Sales report based on the Northwind database http blogs. Create a User with the Right Permissions. I struggled a bit to create a new User that has the permissions necessary to access reports. Perseverance paid off, however. Heres what I did Create a local Windows user PHPDemo. H5ob0/hqdefault.jpg' alt='How To Run Php Program In Wamp' title='How To Run Php Program In Wamp' />User on your machine. You do not need to make PHPDemo. User an Administrator. Standard user is fine. Create a login on your SQL Server Express installation for PHPDemo. User. When you create this login youll want to qualify it with your machine name MACHINENAMEPHPDemo. User. Add PHPDemo. User as a user for the Northwind and Report. ServerSQLEXPRESS databases. Give the user dbdatareader and dbdatawriter priviliges. Modify the rsreportserver. Report. Server installation folder C Program FilesMicrosoft SQL Server MSRS1. SQLEXPRESSReporting ServicesReport. Server in most common scenarios. You might need to open the text editor with Administrator privileges. Add the lt RSWindows. Basic element to the lt Authentication. Types node if other nodes are already included, dont delete them lt Authentication lt Authentication. Types lt RSWindows. Negotiate lt RSWindows. NTLM lt RSWindows. Basic lt Authentication. Types lt Enable. Auth. Persistence truelt Enable. Auth. Persistence lt Authentication Connect to the Report Server Web Service. To connect to the Report Server Web Service, we simply need to create a new SSRSReport object passing in the credentials of the PHPDemo. User and the service URL. If we are toggling an item in the report as we would do when drilling into the products that make up a category in the Sales report, we call the Toggle. Item method. Otherwise, we simply load the report requireonce SSRSReport. UID, MACHINENAMEPHPDemo. User definePWD, PHPDemo. UserPWD defineSERVICEURL, http localhostReport. ServerSQLEXPRESS defineREPORT, Sales ssrsreport new SSRSReportnew CredentialsUID, PWD, SERVICEURL if issetREQUESTrs Show. Hide. Toggle ssrsreport Toggle. ItemREQUESTrs Show. Hide. Toggle else ssrsreport Load. Report. 2REPORT, NULL Depending on how a report is designed, methods other than Toggle. Item exist for rendering a report. For example, if your report allows a user to sort items, the Sort. For a complete list of methods on the SSRSReport class, see the SSRS SDK for PHP User Guide. SDK. Note In Reporting Services 2. To maintain backwards compatibility with older Reporting Services releases, new methods were created with the same name as their old counterparts and post fixed with 2. Render the Report as HTMLNext and last, we render the report as HTML by creating a new Render. As. HTML object. Other methods allow you to render a report as Excel, Word, CSV or Text, XML, Image, and PDF. As. HTML new Render. As. HTML render. As. HTML Replacement. Root get. Page. URL resulthtml ssrsreport Render. As. HTML, Page. Count. Mode. Enum Estimate, Extension, Mime. Type, Encoding, Warnings, Stream. Ids echo lt div styleoverflow auto width 1. Note the use of the Replacement. Root property on the Render. As. HTML type its value is used to replace all links in the generated report with relative links to the PHP page you are using. Here is the get. Page. URL function that returns the current page URL function get. Page. URL Page. Url SERVERHTTPS on SERVERREQUESTURI index strposuri, ifindex false uri substruri, 0, index Page. Url. SERVERSERVERNAME. SERVERSERVERPORT. Page. Url Note See this post for an example of rendering a report as an Excel document http blogs. Really, thats itpretty simple. Attached to this post is a file with the complete source code. Of course, depending on the nature of your report, you might have to write a bit more code to handle postback events, but the basics are here. I think the Interoperability team did a great job in designing the SDKit really makes consuming and displaying reports straightforward from PHP. To dig deeper into the capabilities of the SDK, read the docs that come with the download. Or, if you have questions, ask in a comment here and Ill do some homework. Thanks Brian. Share this on Twitterssrsdemo. Setting Up a WAMP Server. This tutorial will walk you through setting up a WAMP Server using software that can be found on sourceforge for use. First, a little description is an order. A WAMP Server is a Windows Machine that has Apache, My. SQL, and PHP on it WAMP Windows, Apache, My. SQL, PHP To install these before you would have to get the installs and binaries and configure them yourself and set everything up which can be a tedious task as well as very time consuming. Now, thanks to sourceforge, you can get this functionality by simply installing an application. Once you are finished with this tutorial you will be able to follow our web based tutorials without having a domain name andor server. Lets get started. First we need to download our software from wampserver. Once on that site look for the above box to appear and click on Download WAMP Server 2. Save the file somewhere that you will be able to get to once it is finished completing. It is approximately 2. Megabytes, so depending on your connection, it may take a few minutes. You should now see this icon wherever you chose to save the file. Double click on it to start the installation. Select to run the file if you are prompted to do so. You will be prompted to not install this version over WAMP5 1. Click yes to continue with the installation. This first install window simply welcomes you to the installer for this application. Click next to continue. This window contains the GNU GENERAL PUBLIC LICENSE that will allow you to use this software. Once you review this click the I Accepts radial button and click next to continue. This box lets you pick where you would like to install all of the files. You can change this if you like but if you do, bear in mind that you should put it in a folder that does not contain any spaces as some browsersservers have issues handling spaces in file names. This is also where your web files will be stored under a directory called www. If you are unsure, leave this default. This window will allow you to create the desktop icon and the quick launch icon to start the server by the click of a button. This window just reviews all installation options. Verify the settings are correct and click next to start installing the application. This is installing the software. You will get the above prompt to configure Fire. Fox as your default browser for the WAMP Server if you would like, otherwise it will use Internet Explorer. This window will allow you to configure your server to forward any e mail that your php creates to a proper server and e mail account so that they will go to the right person once you are using it. If you dont know these values or have the ability to use them, just leave them default. This is the completion window. You have the ability to launch the server automatically after closing this window if you would like. Click Finish to start the application. Once the server is running, you will see the above icon and the taskbar for the WAMP Server. The above menu is what you will get if you simply left click once on the tray icon. Localhost This option simply open the webpage that is stored in the home directory which is C wampwwwindex. You can also get to this page by typing localhost in your web browser, or by typing 1. My. Admin This option will launch phpmyadmin which can also be launched by going to http localhostphpmyadmin in your web browser. My. Admin is a tool to manage, query, select, and browse your My. SQL databases. It is php based and relatively simple to use. SQLSite. Manager This launches a tool to create and delete entire databases. You use this to create the databases and use phpmyadmin to manipulate the data in them. This can also be access from http localhostsqlitemanager in your web browser. Directory this will open the folder where your sites files are stored. These are the files that are called when you go to localhost. Apache This area has the configuration settings for Apache and will allow you to make configuration that you need to make to this service. PHP This area has the configuration settings for PHP and will allow you to make configuration that you need to make to this service. My. SQL This area has the configuration settings for My. SQL and will allow you to make configuration that you need to make to this service. Then you also have the options to control the services and take the server on and off line. By default the server is set up with an index. This file will also show you the projects that have started on your server based on the folders that are within the www folder. You do not have to keep this file if you do not wish to. Playstation 3 Emulator With Bios Download. You can delete it and make your own index. There are many configurations that can be made to this server setup. Explore them and have fun. Nero 7 Free Download Slovenski'>Nero 7 Free Download Slovenski. I hope this tutorial was easy to follow and thanks for reading.