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.

Attachments

2

Activity

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created March 9, 2023 at 1:46 PM
Updated May 1, 2023 at 5:40 PM
Resolved March 13, 2023 at 6:27 PM