Topic: [SOLVED] Use boolean/calculated field in report
Hello friends,
I have a calculated field in my table which calculates the result of the boolean field in the tablegrid.
case table_field when 1 then 'Yes' when 0 then 'No' else '' end
I have created a dataset to make a report like so
SQLQuery('SELECT * FROM table WHERE table.id = '+form1.Edit10.Text , Results1);
This does not include the calculcated field in the dataset.
My question, how can i include the calculated field, or replicate it, for use in the report? So, if boolean = 1 i want to show 'Yes' in the report.
Kind regards