Tag Archives: ssrs

SSRS Nulls in a matrix

Posted on October 21, 2013 by

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

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

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

SSRS – Using a Parameter to make Dynamic Columns

Posted on June 10, 2013 by

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

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

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

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