- Open the report in Cognos Report Studio and open the query in the query explorer.
- Add a new Data Item and use as Expression Definition:
if([Databasefield] <> '1')
then ('No')
else
('Yes')
- Now open the page explorer and add the Data Item as a column. You will now see a list containing Yes and No values.