Tag Archives: ssrs

SSRS Nulls in a matrix

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

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

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

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

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

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

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