Print Format Script Column does not show Data in correct Data Types
Description
None
Environment
Issue: Script columns on in reports doesn’t assign the correct data type for the data (by default, all data is shown as 'text') - this causes issues with date and number formatting.
Steps to reproduce:
log in to GardenWorld
open an Order Detail print format and navigate to Date Ordered print format item
set Format Type to Script and Script (in section Technical) to @SQL=SELECT DateOrdered
Type Field:
Type Script:
Note: the Format Pattern field is not working either because of this issue.
Issue: Script columns on in reports doesn’t assign the correct data type for the data (by default, all data is shown as 'text') - this causes issues with date and number formatting.
Steps to reproduce:
log in to GardenWorld
open an Order Detail print format and navigate to Date Ordered print format item
set Format Type to Script and Script (in section Technical) to @SQL=SELECT DateOrdered
Type Field:
Type Script:
Note: the Format Pattern field is not working either because of this issue.