Browse by Tags

Related Posts
  • Blog Post: Creating a Shared Dataset with Report Builder

    I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically, can you build a Shared Dataset that combines multiple tables from the same database? To be honest, I wasn't sure initially because I never attempted to. However, after a little testing...
  • Blog Post: SSRS 101 - Prerequisites

    Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things you must have installed or restored before you can begin. As mentioned in my previous post, SQL Server 2012 for Beginners , this is a journey. While the first part of the...
  • Blog Post: Parameterizing an Excel Spreadsheet

    I've had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically about how to pass values from Filters to the spreadsheet. I did a few demonstrations to show the capability to some customers. Immediately after a few of the demonstrations...
  • Blog Post: SSRS 101 – Creating a SQL Server Reporting Services Project

    This is the second installment in this series of SQL Server Reporting Services 2012 Beginner posts. You can read the previous post here . If you are wondering why Beginner, please read the SQL Server 2012 for Beginners post to learn more. With that, let's get started. Before you can create a Report...
  • Blog Post: SQL Server 2012 for Beginners

    I have been working for Microsoft for the past two years. One of the most enjoyable parts of my job is the fact that I work with US Education. I get to evangelize SQL Server and Business Intelligence to Colleges, Universities and Public Schools across the country. I build Proof of Concepts, assist in...
  • Blog Post: SSRS 101 – Creating a Shared Dataset

    Now that you have created a Share Data Source, it's time to add some data to your project. In this post I will explain Shared Datasets and demonstrate how to add a one to your project. As with a data source, you can create an embedded or shared dataset. The primary advantage to creating a shared dataset...
  • Blog Post: SSRS 101 – Your First Report

    I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL Server to public schools, colleges and universities. Now that does not excuse my time away from the blog, but that is my excuse and I am sticking to it. Anyway, back to SSRS. If you have been following...
  • Blog Post: SSRS 101 – Creating a Shared Data Source

    In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project , you will now learn how to create a Shared Data Source within that project. In this post I compare and contrast Shared and Embedded Data Sources and demonstrate how to create a Share Data Source. A Data...
  • Blog Post: SSRS – Using a List Item to Display Details

    How many times have you been asked to develop a report that displays the details for a specified group? For example, maybe you need to produce something like the following report: The above image shows a report that contains three groupings: School, Location and Event Type. Two values, # of Behaviors...