Hello, i have a report in Report Builder 3.0. I just want to add a column that is not associated to any field in the report. All the items in that field must be just a string of characters like "Yes" or anything. Please help.
how would you determine the value "Yes" or anything ?
I wanna fill all that column with "Yes". The information there is from a separate point of view, not in the SQL tables, as i explained above. So don't worry about that.
You can just add the desired word as new column to your existing query.
'Yes' as column4
from your table
SELECT DISTNCT table.column1,
table.'Yes' as column4
no need to put table name prefix just keep 'Yes' as column4
Thank you, it worked. How do i mark this as an answer?