Jump to content
  • 0

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


JRoss

Question

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]

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...