Calculated Field's Select Sql Result Not Showing Up In Download File

[JRoss]

I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank.  I am able to get results if I change the values from 'true' and 'false' to 1 and 0.

 

Has anyone run into this?  We would like the text value of either 'true/false' or 'yes/no'

 

Thanks,

-John

 

select
case
when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True'
else 'False'
end
from JRRESULTSTABLENEW a
join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID
where a.MemberID = [@field:JRCOOKSLISTING_MemberID]

[MayMusic]

It should be a bug in the system and it is already reported.