Problems with Formatting. 1

[McChops]

Please note. This formatting issue only occurs once published to CE. The report prints correctly in Crystal Reports.

This is my post...

http://www.tek-tips.com/viewthread.cfm?qid=1416335

Thanks.

 

[groggle]

Your Your "Year/Month" formula {@Year}&"/"&{@Month Format}
IS producing a string output. When you use & to concatenate a number, it automatically formats it to have two decimal places.

Try Totext({@Year},0,"")+"/"+Totext({@Month Format},0,"")

the ,0,"" part of the totext function tells crystal to convert the number {@Year} and {@Month Format} to a string but put 0 decimal places and use "" (empty string) as the thousands separator.

 

[McChops]

Thanks groggle. Did the trick.