How to format field value in crystal report
-
Could somebody help me to format a field in crystal report. I have a field named "Code" with value is 9393. However, I want to add 0000 in front of it, then it would become: 00009393. I know that in crystal report that have a string function called length and ReplicateString, so that we can use to add 0000 in front of a number. I know the way to do it, but I don't know how to write it in "Format Formula Editor". Could anyone help me on this? thanks. John
-
Could somebody help me to format a field in crystal report. I have a field named "Code" with value is 9393. However, I want to add 0000 in front of it, then it would become: 00009393. I know that in crystal report that have a string function called length and ReplicateString, so that we can use to add 0000 in front of a number. I know the way to do it, but I don't know how to write it in "Format Formula Editor". Could anyone help me on this? thanks. John
if u are using Crystal Rerpots 9.0 then click on view menu select field explorer. from field explorer right click on formula fields and select new. enter the name of the formula. then a new window will appear. in the editor just write "0000" & Code it will do the required thing save it and close it drag the field from the formula fields to the report. hopefully it will help :) computer... :confused: Programming... :confused: whats that
-
if u are using Crystal Rerpots 9.0 then click on view menu select field explorer. from field explorer right click on formula fields and select new. enter the name of the formula. then a new window will appear. in the editor just write "0000" & Code it will do the required thing save it and close it drag the field from the formula fields to the report. hopefully it will help :) computer... :confused: Programming... :confused: whats that