Create reports in SQL Server Reporting Services (SSRS).
We will develop your skills, bit by bit.
You can also download a free version of SQL Server which will allow you to practice creating reports on your own.
We will design a report, implementing report layouts and add interactivity into your reports.
Now I should say at the outset that there were many different versions of a SQL Server Reporting Services and I'm going to construct the one that you can freely download which is secure all Server Express but you may already have another version installed you might be in a corporate environment where you've got Sharepoint for instance and that the SSL S is a bit different. I've got to look at the differences in this particular lecture but first of all I also want have a look at exam 4:17 6:6 which is Microsoft's exam for ss r s and s s s the analytical services and he can see concentrates 25 to 30 percent on ISIS R Us. Now there are seven key elements designed to report implement a report out and implement interactivity in a report. Those are the three that we're going to be concentrating on in this course. The others are more requirements more needing Sharepoint installed. And this particular cost does not require Sharepoint to be installed. So those things we all go to to configure authentication and authorization for reporting's to action troubleshoot reporting services issues manage your reporting environment and configure report data sources and data sets will do that to a certain element. So what is going to do around Frina half out of the 7 we're going to be concentrating on the actual designing reports implementing Portlaoise and implementing interactivity. So in other words the actual doing of the software or the administration of it doesn't say this course is going to focus on one that's freely available so that everybody can join in. Yes go server express my personal preference if you're not in a corporate environment is to spend £50 $70 on a server developer. No reason for that is that the developer license basically gives you everything including. I guess the integration services. And I says Yes the analysis or analytical services and this free version does not. It just gives you the SS M-S the management studio and SS R Us do reporting services that we're going to construct. Now if you've got Sharepoint then you've got different entry into the program that you're going to use and the program you're going to use looks quite a bit different in some respects to the one that I'm using so the rest of this lecture. Could you just have a look at the differences and the similarities. Now if you are using SS r s and check onto the corporate environment you are more likely to be using the report builder which you can access through Sharepoint by clicking on repo builder. You can also create new data sources as well for this lecture or this series of lectures. We're going to be looking at a different version which is incorporated within Microsoft Visual Studio. Now this is variously called Ask yourself data tools in the server business Server 2012 2014 2016 EDITION. It's also called Visual Studio. If you've already got the 2010 2012 2013 or 20 15 version downloaded and it's also cool beads if you're using. Also the 2008 or 2008 R2. So there's a lot of different terminology. They're all basically the same program. We've two major differences. First of all have a look at the ribbon. You can see that up here this is a conventional tool bar one that you probably saw in Excel 2000 of free while I was in the report built list for version 2 and version 3 not for Version 1 we have a ribbon that you see in more in the 2007 version of excel in a word. It's a blue ribbon wave clickable items as opposed to menus including a file menu. So this is the version we're going to use That's the first major difference. And I'll have a look at the ribbon on the report Bodor in just a moment. The different version difference is that the visual studio is more adult more debt in having multiple reports being corrected in the same environment that you can see about them in different types. Not so much in report but the report is primarily concentrating on the one report or it is a report boda rather than something a bit more grandiose. So to that extent this solution explorer does not exist or at least not in the same format as in the Hip-Hop. And so if using the report Boulter and I'm creating a dataset for instance or a data source you don't do it over here because over here doesn't exist in pop. Instead you do it over in the left hand side as you can see here. Or if it's a data source you do it in Sharepoint itself. If you want to make a shared data source. So if I go over here and ask your server data tools but it's visual studio and you're using Report builder then go to the Latin side. Now you can see it is a cleaner interface from a potholder. It's a bit more graphically nice but to be honest when you get into the really big detail it might be a bit more limited but we're not actually going to run into that limitation. For instance you can see in my version there's a certain lack of formatting tools or at least the work before I actually had someone to see me add them in future lectures. Well was there a standard in report builder. We have a preview button and this is probably one of the more significant differences. Whenever we design a report in Visual Studio 60 T and want to see it run we click the preview button. If you want to do that in report boder you click the wrong button which is part of the home type. So also we have a tool box which is actually the out of the way here. And that's for inserting items. Now when you want to insert an item and you want to something equivalent to a box you go to the insert money which gives you the identical things. So let's just have a quick look at the ribbons that you got in report Boulder. First of all you have the home so that you run which is aquarists the preview copy paste lots of font paragraphs Balder's numbers and a line on it. So basically the same sort of tools that you would have on the home page on top of exile on the Insert tab. We've got all the things which we will find if you right click in an empty space on the report or if you go to the tool box there's a subset of the toolbox in SSD doesn't have the father but it does have all the others report box parts is something that's additional in Boulder what that is is you created something and you want to use it and in future report you can save the report box but there is a view tab there's very little in it just for things you can take and I suggest you keep them all ticked. So basically just ignore that. There's also a file menu which is this one. And you can see it's got various different icons. Well it does depend on which version you download or which version you got installed so I can cover them all. But you see it's basically a new open to save and save us. And then when you click run you get a different toolbar which allows you to go back to the design. So you are able to go back to designing your new which is the equivalent of the design but had design in your report and you have Zoomer and various pages and basically everything that we have in SSD. We just have it in a different format. So hopefully you now know the differences between people built on SSD and you may in fact have both on your computer if you do have Sharepoint is entirely depends on your constructor. So if you have Sharepoint you now know how to create your initial report click on report bodach. You can also create data. You don't know how to correct data sources you don't necessarily know the dialog boxes but the good thing about Paul boder and SSD. The comparison between them is that the dialog boxes are almost 100 percent identical and those are the real things including the proof the properties pain which will get to if you like just time and that's where I spend most of my time designing making sure that everything is tweaked just right. So there are more similarities and differences. It's just that we're all bolder at least compared to the version that I'll be using in this series of courses looks a bit more professional. It looks nicer looks cleaner but there's very few other variances between them. So if you are using a folder you can now get the next lecture which is all about downloading and installing the Express version of Microsoft a secure server. Then the next like Tresor that is about downloading and adding to the system. The Adventure Works database and I suggest that's where you go next. If however you don't have any version of Microsoft s crossover that includes SRS which includes as I said the various names SSD bits Visual Studio then next lecture I'll show you exactly how to get it for free.