With 2005 (I think 2008 is the same although I do not know from experience) it is not possible with the standard report manager. I have heard of people...

The way I typically handle it is similar to Jack's #2 option although I do the check in the where clause. So it would be more like

Select columns

From table

Where...