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.
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!