title: Custom Reporting Table Query Boolean Column
body: <p>I am new to Kentico and really enjoy developing so far! I have exhausted all search efforts and thought I'd reach out to the community. I am creating a custom report (table to be exact) using the reporting built into Kentico. I have a custom query:</p>
  
  <pre><code>Select FirstName as [First Name], LastName as [Last Name], Email, Phone, StreetAddress as [Street Address], City, State, Country, Zip, Email, Phone, PaymentDate as [Payment Date], TransactionID as [Transaction ID], PaymentStatus as [Payment Status]
  from TableName E
  WHERE E.ID = 1 AND E.PaymentStatus = False
  ORDER BY E.ItemCreatedWhen ASC
  </code></pre>
  
  <p>The issue that I find is that PaymentStatus is coming thru as a "Checkbox - unchecked or checked" instead of True or False. In the actual table and data it shows True/False. Is there any way around this? Thanks for your help!</p>