Area Chart - Need to Show Empty Area instead of Zero

It's been awhile since I created my last report. Recently, I had to pick this up and create a burn down area chart. The remaining work data is set to something like "=iif(fields!date <= today(), sum(fields!remainingwork.value), nothing). I was expecting to see a nice cut off line of the burn down chart on the current day, where future days is blank. However, the report zeros the data on the next date and the chart ended up with a sharp line from the remaining work of the current day down to zero on the next day. After some digging around and playing around, I found out that this issue can be fixed by simply setting the EmptyPoint\Color to "No Color". Here are the steps: 1. Select the data series on the chart design section. 2. On the properties panel, expand the EmptyPoint node and set the color to "No Color". Simple as that.

Adding Line Feed in A Text Box

If you need to have multiple lines in a SSRS text box, VbCrLf is what you need.

Example:
="adbc" + VbCrLf + "xyz"
Result:
adbc
xyz

More details at:
http://stackoverflow.com/questions/26567/how-do-i-set-a-textbox-to-multi-line-in-ssrs

Fixing The Custom MDX Lost in Report Designer Problem

Recently I encountered a problem with the SSRS 2005 Report Designer. When I opened a report with custom MDX code and go the data tab. The dataset view screen automatically went to the design view and wiped out the custom MDX code. The problem started occuring when I uninstalled SQL 2005 Express edition and installed the Enterprise edition. I found a post on the Internet that talks about similar situation. (http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/fca63464-cffb-4208-99e4-c0a53c3686a0/)

Because of the issue mentioned in the post, the Report Designer couldn't parse the MDX code. It automatically went back to the design mode when that happends because that's the "Previouse State" of the data set.

Installing SQL Server 2005 SP2 fixed this problem.