April 15, 2019, 03:30 PM
MartinYI know that this seems to be simple but what if you define your xml as below
SET ASNAMES ON
TABLE FILE GGSALES
SUM TOTAL COMPUTE SEQ_NOX /A7 = LJUST(7, FPRINT(SEQ_NO, 'I5', 'A7'), 'A7'); AS 'VALUE'
BY SEQ_NO AS 'CODE'
ON TABLE PCHOLD FORMAT XML
END
-RUN
Then you use VALUE as for the "Display From" and CODE as "Value From" in the control settings.
You will have the alpha value displayed as left justified but will return the numeric one to your fex.
April 16, 2019, 08:52 AM
TexasStingrayYes, I did that and it does work. However, I have a lot of procedures that now need to be updated there has to be a way to tell it not to do that. Seem like a lot of work for something that should be easy.
Scott
April 16, 2019, 09:28 AM
MartinYAgree.
To be honest, normally I don't have any list where the display is only a numeric field so, I haven't faced that issue.
I have to list a description with a code (number) so everything become a char as the displayed value but I return the number to the fex.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007