Category Archives: SSRS

SSRS – Using a Parameter to make Dynamic Columns

Posted on June 10, 2013 by MikeDavisSQL

Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually show on a report. You will need to create a multiple value parameter and place an expression on each column … Continue reading →

Posted in SSRS, Syndication | Tagged | 6 Comments

Studying and Learning Business Intelligence

Posted on October 2, 2012 by MikeDavisSQL

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to … Continue reading →

Posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training | Tagged , , | 2 Comments

Crystal Reports DataDate in SSRS

Posted on July 16, 2012 by MikeDavisSQL

Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has been executed. A recent client asked for the similar functionality in SSRS when a snapshot is run. They wanted to … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

The IRS and SSRS

Posted on April 16, 2012 by MikeDavisSQL

Recently I did a webinar on the IRS and SSRS. In this webinar I covered creating reports with images and forms. I also covered how to manipulate data and showed you how to cheat on your taxes(not really).You can download … Continue reading →

Posted in SSRS | Leave a comment

How to use Report Builder 3.0

Posted on April 16, 2012 by MikeDavisSQL

I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar I showed how to pull data from Stored Procedures and Shared Data sets. I also showed the issues that come … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment