Home > IT Answers > How can I make a numeric field left justified in report?
RamvishakRamesh
1,880 pts.
 How can I make a numeric field left justified in report?
Uncategorized
Is there any edtcode to make the numeric field as left justified? I dont want to convert it to character. Any suggestion?

Software/Hardware used:
AS400
ASKED: October 1, 2012  12:24 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Is there any edtcode to make the numeric field as left justified?   No. 
 
I dont want to convert it to character. Any suggestion?  No… except for the type of solution you’ve already rejected. 
Use the %TRIM(%EDITC …) in the C spec (for free format) to populate a character field and use that field in the O spec’s or Printer file.

philpl1jb
 44,060 pts.
 

Sorry, way ahead of myself.  You haven’t told us how you generate the report.

philpl1jb
 44,060 pts.
 

I dont want to convert it to character.
 
That’s contradictory. If you put it into a report and left-justify, it will be character.
 
The “left-justify” implies suppressing leading zeros. As soon as you do that, you must convert to characters. And if you want to keep leading zeros, then there is no need to “left-justify”.
 
Please show examples of values, and show how you want those examples to print.
 
Tom

TomLiotta
 107,695 pts.