Skip to Content
author's profile photo Former Member
Former Member

Forcsing number formatting in Select statement

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 25, 2010 at 02:21 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.