THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSRS   (RSS)
Showing page 1 of 3 (30 total posts)
  • DevWeek 2016 BI in SQL Server 2016 Workshop Setup

    I got some questions about virtual machine / notebook setup for my Business Intelligence in SQL Server 2016 DevWeek post-conference workshop. I am writing this blog because I want to spread this information as quickly as possible. There will be no labs during the seminar, no time for this. However, I will make all of the code available. ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 15, 2016
  • Review of the book SQL Server 2012 Reporting Services Blueprints

    Recently I had the opportunity to read the book SQL Server 2012 Reporting Services Blueprints written by Marlon Ribunal and Mickey Stuewe and published by Packt Publishing. First, I have to tell you that I am not a Reporting Services guy, I have much more knowledge on other topics such as Database Development, Performance Tuning, and so on. ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 25, 2014
  • SQL Server 2012 Reporting Services Blueprints Review

    I had opportunity to read the SQL Server 2012 Reporting Services Blueprints book by Marlon Ribunal (@MarlonRibunal) and Mickey Stuewe (@SQLMickey), Packt Publishing. Here is my short review. I find the book very practical. The authors guide you right to the point, without unnecessary obstructions. Step by step, you create more and more complex ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on January 8, 2014
  • SSIS Reporting Pack – a performance tip

    SSIS Reporting Pack is a suite of open source SQL Server Reporting Services (SSRS) reports that provide additional insight into the SQL Server Integration Services (SSIS) 2012 Catalog. You can read more about SSIS Reporting Pack here on my blog or had over to the home page for the project at After having ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 5, 2012
  • Multi-State Maps in Reporting Services

    In SQL Server 2008 R2 Reporting Services, you can now create maps for reports using the built-in map gallery of the United States or individual states, ESRI shapefiles, or a spatial query. In a previous post, I explained how to obtain an ESRI shapefile for another country and convert it into spatial data so that you can have other maps available ...
    Posted to Stacia Misner (Weblog) by smisner on March 24, 2011
  • The Case of the Extra Page: Rendering Reporting Services as PDF

    I had to troubleshoot a problem with a mysterious extra page appearing in a PDF this week. My first thought was that it was likely to caused by one of the most common problems that people encounter when developing reports that eventually get rendered as PDF is getting blank pages inserted into the PDF document. The cause of the blank pages is ...
    Posted to Stacia Misner (Weblog) by smisner on March 18, 2011
  • Applying Interactive Sorting to Multiple Columns in Reporting Services

    A nice feature that appeared first in SQL Server 2005 (not SQL Server 2008 - I mis-remembered!) is the ability to allow the user to click a column header to sort that column. It defaults to an ascending sort first, but you can click the column again to switch to a descending sort. You can learn more about interactive sorts in general at the Adding ...
    Posted to Stacia Misner (Weblog) by smisner on March 16, 2011
  • Working with Reporting Services Filters–Part 5: OR Logic

    When you combine multiple filters, Reporting Services uses AND logic. Once upon a time, there was actually a drop-down list for selecting AND or OR between filters which was very confusing to people because often it was grayed out. Now that selection is gone, but no matter. It wouldn’t help us solve the problem that I want to describe today. As ...
    Posted to Stacia Misner (Weblog) by smisner on February 4, 2011
  • The Case of the Missing Date/Time Stamp: Reporting Services 2008 R2 Snapshots

    This week I stumbled upon an undocumented “feature” in SQL Server 2008 R2 Reporting Services as I was preparing a demonstration on how to set up and use report snapshots. If you’re familiar with the main changes in this latest release of Reporting Services, you probably already know that Report Manager got a facelift this time around. Although ...
    Posted to Stacia Misner (Weblog) by smisner on January 25, 2011
  • Working with Reporting Services Filters - Part 4: Creating a NOT IN Filter

    A question came in from a reader asking about how to create a NOT IN filter. You can see in the first of this series of blog posts about Reporting Services filters, NOT IN is not available in our list of operators for filters. However, it's still possible to produce a filter that excludes items in the list. The technique is not particularly ...
    Posted to Stacia Misner (Weblog) by smisner on January 20, 2011
1 2 3 Next >
Privacy Statement