I created a Report Model based on a relational DB. I used the autogenerate option. I came to show it to my user, and he noticed that one of the attributes showed just the date, without any time. I looked at the field in my DB and saw that indeed it was of type DateTime and had data about time in it as well as the date. Looking at the format Report Model automatically gave the attribute, I saw the format was “d”. I remembered that usually I could copy the format I wanted for a field from the format...
Creating Sum for a Group with Recursion in SSRS Sum with scope A colleague of mine from work was creating a report with Reporting Services 2005. He had a matrix report like the following: Year Total Total Sales Per Year % of Sales from the Total Sale Per Status Status 1 Total 2 3 He wanted to calculate the percent of total for that year from the total for that row. I remembered from looking at the Sum function in SSRS that it had 3 options – with scope and recursion. So I thought – I should try the...