Category Archives: SSRS

SSRS Top N and Bottom N reporting with Duplicates

Posted on March 3, 2014 by MikeDavisSQL

Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did not cover in that blog so I thought I would cover those here to answer some of the questions I … Continue reading →

Posted in SSRS, Syndication | Tagged | 2 Comments

SSRS Report Models no Primary Keys

Posted on February 17, 2014 by MikeDavisSQL

When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading →

Posted in SSRS | Tagged | Leave a comment

SSAS Reporting Action with Date Parameters

Posted on January 20, 2014 by MikeDavisSQL

Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the … Continue reading →

Posted in SSAS, SSRS, Syndication | Tagged , | Leave a comment

SSRS Interactive Sorting a Matrix

Posted on December 30, 2013 by MikeDavisSQL

Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as … Continue reading →

Posted in SSRS, Syndication | Tagged | 1 Comment

SSRS – Self Referencing Reports or Drill through to same report

Posted on December 2, 2013 by MikeDavisSQL

When looking at a report and wanting to drill through to get more detail, we often create two reports for this. This can be accomplished by just one report by creating a self-referencing action that links to the same report. … Continue reading →

Posted in SSRS, Syndication | Tagged | 4 Comments

Reverse or Mirrored Bar Chart in SSRS

Posted on November 25, 2013 by MikeDavisSQL

There are some pretty charts out there and most of them can be done in Reporting Services. There is one type of chart I had someone ask for that is not natively built in to SSRS. But with a little … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

SSRS Map Layers Parameter

Posted on November 11, 2013 by MikeDavisSQL

With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to … Continue reading →

Posted in SSRS, Syndication | Tagged | 1 Comment

SSRS Nulls in a matrix

Posted on October 21, 2013 by MikeDavisSQL

In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the … Continue reading →

Posted in SSRS | Tagged | Leave a comment

Custom Coding in SQL Report Services

Posted on July 29, 2013 by MikeDavisSQL

Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you to place complex expressions on reports in every field. Even with all of these tools there are some instances where … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

Report from a Cube in Reporting Services

Posted on July 8, 2013 by MikeDavisSQL

Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop an Analysis Services cube which allows for fast reporting. Creating reports in Reporting Services 2008 from a cube is very … Continue reading →

Posted in mdx, SSAS, SSRS, Syndication | Tagged , , | 3 Comments