Tag 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

Using PowerPivot to Monitor Reporting Services

Posted on June 12, 2012 by MikeDavisSQL

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you can download for free here. In this blog I will give you a PowerPivot workbook that I created to connect … Continue reading →

Posted in powerpivot, Syndication | Tagged , , | 2 Comments

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

SQL Saturday Orlando – Pre Con

Posted on September 7, 2011 by MikeDavisSQL

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works … Continue reading →

Posted in SQL Saturday, Training | Tagged , , , , | 2 Comments