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

Report on your reports

Report on your reports

When you deploy your SSRS reports, you might want to know about how they perform. Or maybe your reports perform allright, but there might be improvements on how the end users can be presented with the reports even faster. Also, you might have deployed a bunch of reports that nobody reads but they’re just sitting there… To get insight into these things, the ReportServer database has a few tables that contain log records of your reports. First of all, by…

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

Refresh local cache for IntelliSense

Refresh local cache for IntelliSense

I have come across many situations where I had a SQL Server query window open and I changed something in my table definitions. This resulted in not being able to use the IntelliSense on those new columns or tables. In SQL Server Management Studio, you can refresh the IntelliSence cache by pressing Ctrl+Shift+R, or go to Edit – IntelliSense – Refresh Local Cache: It takes a second or two when the query has been updated, but at least you can…

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

Error message explained: The ‘Role’ with ‘ID’ = ‘Role 1’ doesn’t exist in the collection.

Error message explained: The ‘Role’ with ‘ID’ = ‘Role 1’ doesn’t exist in the collection.

It could happen that you move around your cube files and with the deployment, you run into some errors. A common error that I’ve encountered again is the following. The ‘Role’ with ‘ID’ = ‘Role 1’ doesn’t exist in the collection. This happens mostly when you have copied a .cube and .partitions file to another project and added this to the new SSAS project/solution. The underlying meaning of this error is that in your cube file, you have a role…

Read More Read More