If you make a report in Reporting Services report that you want to export to Excel often. Reporting Services also screwed quite a bit on the layout. As columns, which are often not really hear you often closing problems.

Problem 1: columns are inserted
After your a report from Report Manager, you have exported to Excel so we want them to do many calculations. The problem is that Reporting Services often insert columns so that the calculations difficult to apply.























The cause is the use of Report Items, for example in the header of your report. Example, you can report title in your header already.

























You will see that Excel on the very spot where the Report Item ends the columns are split. Thus, in the example above, an additional column be inserted at the spot where the arrow is.

The solution is to ensure that the end of the Report Items exactly at the junction of a column falls from such a table, as in the picture below.





























Problem 2: I get more decimal comma what I specified

The "format" field of a cell, you can specify how the output of a cell should be. So you "c" for the output to a euro sign (currency), D2 and P2 for 2 decimal places for a rate of 2 digits. Suppose you fill in a particular cell P2 and the value of this cell is 0.4222 then the outputs are "% 42.22 ', we have indeed given us two decimal comma wanted. As a result we then export to Excel, we often notice that suddenly there are three digits after the comma! This is because Excel does not consider the reported P2 but to the outcome of the dataset.

The solution to the cell or in the dataset Round. Suppose we number with two digits after the comma like we have four digits after the comma Round (0.42 and you'll get it down to around 42%). Rounds are made with the following expression: = Round (Feels! Omzet.Value, 4)
Of course you can do this in your dataset. You only care that you get when you do not rounding this number is then used in calculations.