Browsed by
Category: Reporting Services

Using SSAS dimension data with different labels

Using SSAS dimension data with different labels

In relation to my article about using date pickers to filter SSRS cube data, I have been asked a few times how it would be possible to use one set of parameters to select the date range that points to dimension data from different cubes.For example, I have a report that pulls data from two different cubes. In the one cube, the main time dimension is called “Date”, and in the other cube there is a time dimension that is…

Read More Read More

SSRS: Using date pickers to filter SSAS cube data

SSRS: Using date pickers to filter SSAS cube data

When you have a report that pulls data from an SSAS cube, you have most likely used a date range filter on which time series you would like to display. It is not so straightforward though, to create date-parameters in SSRS and in your MDX query you refer to these queries. Because MDX needs to interpret the date values in a completely different syntax, we have to format the data. This post shows you how to accomplish this.┬áThis post does…

Read More Read More

Open SSRS action link in a new window

Open SSRS action link in a new window

From an SSRS report item, you can choose the “Action” in the properties to link basically to anything. The most popular ones to link to, are another report or an external URL. Personally I’ve used the URL actions the most, but somehow it’s not possible to select if you want the page to open in a new window or in the same window. By default, Reporting Services wants you to view the linked page in the same window.But what if…

Read More Read More

Dynamic grouping in SSRS reports – Part 1

Dynamic grouping in SSRS reports – Part 1

It happens to me lots of times that I’ve created an SSRS report, grouped on a certain dimension, and while the end user is happy with the result, I get the question back “Can I also group this table on this-and-this dimension as well?“. Well, sure you can! You can create a second tablix or even a second report that retrieves exactly the same data but then you group the table on another dimension. I was at that stage where…

Read More Read More

Description for an SSRS report in BIDS?

Description for an SSRS report in BIDS?

Usually when I deploy a report from the Business Intelligence Development Studio to the Report Manager, I add a short description in the Report Manager what the report is all about or where I can track back the definitions of the report. It would be really helpful if I could already set this description in Visual Studio when I design the report, but unfortunately this option is not there. It looks like a minor thing that would be nice to…

Read More Read More

Use of the field ListLevel in SSRS

Use of the field ListLevel in SSRS

In SQL Server Reporting Services, there is the property “ListLevel” that you can use in your tables to add some padding to the different groups that you have created in your tablix. It’s nice to have that feature available, but I use other methods because of these reasons: You have no control over how much space is added when the text is indented. If you have several list levels and also multiple levels in your tablix that you can expand…

Read More Read More

Avoid SSRS to change your customized MDX datasets

Avoid SSRS to change your customized MDX datasets

I’ve experienced many times that when I changed the main dataset in SSRS (that reads from an SSAS cube), that the datasets of the parameters are changed again automatically. This has usually been a very annoying thing because I change the MDX in the parameter datasets very frequently. To avoid this automatic change, you can add SuppressAutoUpdate=true in the code of your report that suppresses the change of this MDX. Right click the report and choose View Code. Find the…

Read More Read More

Use colors in your reports consistently

Use colors in your reports consistently

I’m in the process of creating a financial report that in the meantime has blown out of its own proportions. Some changes that seems like easy changes have to be changed in so many places that it’s not so easy anymore. One of the things was to set colors for percentage figures that represent things like turnover compared to budget, costs compared to last year, and so on. If it concerns income, everything under 90% should be colored red, everything…

Read More Read More

Deploying SSRS reports larger than 4 mb

Deploying SSRS reports larger than 4 mb

When you have an SSRS report with a file size larger or close to 4 megabytes that you want to upload to the report server, you might get the following error: System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. —> System.Web.HttpException: Maximum request length exceeded. This has to do with the limit on the report server that by default, it only allows files up to 4 megabytes. To increase the allowed file size, you have…

Read More Read More

Matrix with “other” column

Matrix with “other” column

In my earlier blog post “Group small values into an ‘other’ category in a Reporting Services chart“, I talked about how to group small values together into a chart under one category called “other”. Currently I am in the process of setting up a similar idea for a matrix. I have generalized the business case as much as possible to make it easy to understand. In the case, I have several departments where I want to report costs figures. These…

Read More Read More