i also tried to define a dataset with visual studio 2005 (for the SSRS report) like this:

select NULL as department

union all

select distinct upper(department) from subset

order by department asc

DOESN'T WORK!