Anchor | ||||
---|---|---|---|---|
|
Version
XFRX 22.4
Symptoms
Some numbers contains letter a Z in all outputs.
Cause
- Text field has source of data type number
- Seted to "Character" on Format page of text file properties
- After changing to "Numeric" is sets "Blank if zero" too
In the case VFP store format mask to PICTURE column in the format "@Z 9....".
Workaround
Set data type to numeric in report designer
Hook object for fixing bug in XFRX#INIT
Code Block |
---|
loSession=EVALUATE([xfrx("XFRX#INIT")]) loHook=CREATEOBJECT("xfrxhook") BINDEVENT(loSession, "setReportParams", loHook, "setReportParams") loSession.ProcessReport(lcPath+"test2.frx") UNBINDEVENTS(loSession) DEFINE CLASS xfrxhook AS custom PROCEDURE setReportParams LPARAMETERS loo LOCAL m.liSele m.liSele=SELECT() SELECT UR_REPORT REPLACE FILLCHAR WITH "N", PICTURE WITH STRTRAN(PICTURE, "@ Z ", "@Z ") FOR OBJTYPE=8 AND FILLCHAR="C" AND ATC("@ Z ", PICTURE)>0 SELECT (m.liSele) RETURN ENDPROC ENDDEFINE |
Fix report
Code Block |
---|
USE "somereport.frx" REPLACE FILLCHAR WITH "N" FOR OBJTYPE=8 AND FILLCHAR="C" AND ATC("@Z ", PICTURE)>0 USE |