Hide Columns By Condition in TFS Reports

I was asked to create a TFS report that will show all the changes that where made in “Requirement” work items in the last tow weeks.

The problem was that I didn’t want to see columns that are empty…

What I did is to take from the data base everything, but if one of the columns das not hold any changes(data) it will simply be hidden.

Example:

I have a report that one of the columns returned no values, but it might next time.

I would like to hide this column only when it is empty in all the rows.

So I will go to the properties of that column and choose to change the ‘Hidden’ property from ‘false’ to ‘Expression’.

Then I insert a condition to hide the column if it contains no values.

This way I can select many columns from the data base and hide the one that will bare no results!