Altered SQL script to explicitly list all column names, with aliases used in formula columns
(i.e., '' AS [GL Category] ). This allowed me to put the column headers all on the same row.
I think this should address the extra "NA" or "~" column from appearing in the dataset filters.
Still in process - filters aren't getting saved to the template on SQL grids. Fix coming.
Same change made to all 3 P21 Upload templates:
Altered SQL script to explicitly list all column names, with aliases used in formula columns (i.e., '' AS [GL Category] ). This allowed me to put the column headers all on the same row.
I think this should address the extra "NA" or "~" column from appearing in the dataset filters.
Still in process - filters aren't getting saved to the template on SQL grids. Fix coming.