Hi,
When i am displaying some text if i adjust the text box length and width according to it it is displaying but when i am trying to adjust text box of type number it is not displaying the output.
eg. my text box of number in detail section. when i tried to reduce its width and increase its length by dragging down area it is displaying ######### instead of number.
Can any one please let me know the option to adjust the field in CR.
Thanks in advance.
Loading
Sivaraman DhamodaranPosted Nov 8, 2010, 9:23 PM
Solution1:
Increase the field length to hold maximum number
Solution2:[Do it on your Risk]
Write a formula to convert the number to string and display it. As you have text as number trucation is allowed and you do not see ###
Note:
Let me say, You have report for Bank accounts. The detail section has the following columns:
1. AccountID
2. Customer Name
3. Customer Address
4. Bank Balance
Do you allow truncation for the Bank Balance? Got the seriousness? That's why report does not display a truncated numbers if length of text is not sufficient. Hope this helps.