Skip to main content

Posts

Showing posts from February, 2013

Creating a master detail report in SSRS without using Sub report

Creating a master detail report in SSRS without using Sub report. Posted: February 26, 2012 in SqlServer Reporting Services , SSRS Tags: CRM SQL Reporting Services , SSRS 2 Suppose we have simple master ( Person ) and detail ( Favorite Actor and Favorite Movie ) tables in our database . To write a report that doesn’t make use of sub reports we need to have a single dataset as shown below Create a new report project and drag the List control for Master table and two Tablix inside List for the detail records. Select the list and set Group Properties for the Row Groups as shown below. Select the row for the first tablix that shows Favorite Actor information, right click it and specify group properties as FAID (i.e. primary key for that table) Do the same for the other tablix (Movie table). Run the report, it will show the following output To hide the tablix if there is no data, set its Hidden Property using th

SQL Server Reporting Services 2008 Installation Tutorial

This article is a step-by-step walk through of SSRS 2008 installation on a virtual machine. If you are going to install SSRS on a physical machine, then the steps are still similar and you can benefit from it. Environment Check List To follow the steps, you would need to have the following programs installed and configured on your machine: Have already setup a virtual machine. I am using VMware with Windows XP as guest operating system (if you need help to do this, read article: How to install VMware Player? ) Have already installed SQL Server 2008 R2 on your machine ( without the Reporting Services ) Have already created an ISO image from the installation disk (If you need help to do this, read article: How to create ISO disk image? ) If you have the above installed and ready, here are the steps: 1 . This first thing we need to do is to boot the virtual machine. Once the guest operating system is on, we have to mount the optical disk drive to the ISO image

SSRF CONFIGURTION

If this is your first time creating an SSRS report, then this is the right article for you. Below is a step-by-step guide that will help you to create, deploy and view your first report using SQL Server Reporting Services 2008: Environment Check Assuming the following are installed and already configured on your machine: Installed SQL Server 2008 R2 Installed AdventureWork Sample Databases (You can visit Microsoft website to download and install it: http://msftdbprodsamples.codeplex.com/releases/view/55926 We are using it in this case as a sample database. However, you can write any SQL statement on one of your pre-installed Databases) Installed SQL Server 2008 Reporting Services (If you have not done this, visit this post: SSRS 2008 Installation Guide ) Both SQL Server and Reporting Services are installed on the same machine (localhost) Now we can start the guide walk-through: 1. Open SQL Server Business Intelligence Development Studio