Forcsing number formatting in Select statement

[Former Member]

Hi. I have a select statement that truncates a number field and compares it to a parameter, but it doesn't work in InfoView or as a scheduled report in Crystal Server.

The string is :

left(totext({gl_begbal.prd-yr-no}),4) startswith totext(year({?Pm-?Period Ending Date}))

The number field is yyyymm, but Crystal Reports displays the field as 201,006, which causes the select statement to fail. When I set Options, Fields, Number to whole number, CR displays it without the comma and the statement works perfectly. However, when I bring the report into CServer or fun it in InfoView, the report fails again, and I can't find any formatting options in either Server or InfoView settings.

Is there a way to forcse the format to whole number within the select formulae?

Thanks!

Robin

[former_member11696]

Post your question to the BOE Admin forum. Likely what is happening is the BOE server has a different default date format.