Last post Apr 30, 2011 08:05 AM by sansan
Apr 29, 2011 02:37 PM|RuthlessRoth|LINK
whne there is a boolena field and I select Yes/No instead of True False
I get Yes but do not get the No
Crystal XI any suggestions to get both Yes or No on the report?
Apr 30, 2011 08:05 AM|sansan|LINK
you can get Yes/No in stored procedure. Modify your query to return Yes/No accordingly
SELECT Column1, Column2,Column3,
CASE WHEN BOOLEANCOLUMN=1 THEN 'YES'
WHEN BOOLEANCOLUMN=0 THEN 'NO'
ELSE '' END BooleanColumn