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

Monitor your SQL database size and disk space

Monitor your SQL database size and disk space

I faced the challenge of retrieving information about the size of different databases on different servers and the disk space left on the server. Basically I wanted to find a way how I can retrieve this data periodically so I could monitor the growth of the databases and the disk space left. I decided to create an SSIS package from this that loops through the servers and databases to get the information out of it from one single package. In…

Read More Read More

Hierarchical data with SCD Type 2

Hierarchical data with SCD Type 2

The question that is always asked with storing data with Slowly Changing Dimensions, is to what extent you want to keep the historical data. I would like to explain a situation of hierarchical data that is stored with the SCD method and how this affects the data. As an example where I first got in touch with this subject, I’ll take the hierarchical relationship between employees and managers. The employees’ data is stored as SCD Type 2, and this table…

Read More Read More

Dimensional model in SCD2 (part 2)

Dimensional model in SCD2 (part 2)

Continued from part 1: In addition to my previous post, I thought it would be helpful to display screenshots of how I designed my dimension. This is the attributes tab: … and this is how the attribute relationships look like: With these attributes, I would like to be able to do analyses like the number of resources per gender, per country, per cost center, per language, etc…

Dimensional model in SCD2 (part 1)

Dimensional model in SCD2 (part 1)

This post is dedicated to an issue I’ve been dealing with for a while now and until so far I haven’t found a solid solution yet. Since I’ve been explaining and asking this to several experts over and over again, I’ll dedicate a blog post to it. I’m a big fan of using Kimball’s Slowly Changing Dimensions, especially since it keeps track of historical data and it doesn’t explode your database. But… mapping this data into an SSAS dimension is…

Read More Read More

Today I found an interesting and extensive article about the new features in SSRS 2008 and 2008 R2: New features in Reporting Services 2008 and 2008 R2

Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

Yesterday I stumbled upon this whitepaper that gives a real good insight in the technical concepts and techniques that are used to implement reports with SQL Server 2008 Reporting Services, using an Analysis Services cube as the data source: Link to whitepaper

Formatting your URL with data from Synergy Enterprise in an SSRS report

Formatting your URL with data from Synergy Enterprise in an SSRS report

Have you already heard that the Microsoft SQL Reporting Services has been integrated in Exact Synergy Enterprise 243, that has been released recently? If not, have a look here on the Exact Product Blog. If you’ve been creating reports in SSRS to integrate in Exact Synergy already, you must have worked with hyperlinks that lead back to an internal Synergy page. For example, you have a report with a list of customers, and the name of the customer in the…

Read More Read More

Group small values into an “other” category in a Reporting Services chart

Group small values into an “other” category in a Reporting Services chart

The following chart is a simple pie chart from the Adventure Works SSAS cube (Analysis Services) where I show the reseller’s gross profit by product in the United States. As you can see, it’s trying to squeeze in all the products into the pie chart with very small numbers for a lot of products. But what to do when you are only interested in the products that are selling the best? So basically I would like to show the top…

Read More Read More