NickStiven
Technical User
I have written a report in Crystal 9 which groups names by school terms and years. What I want as a group name is, for example: SUM 2003. My formula for the combined term and year string for the Summer Term 2003 is:
If {pupil.entryterm} = "SU " then "SUM " + ToText({pupil.entryyear})
The Crystal File/Options/Fields/Numbers/Number settings are Decimals to 1 and Rounding to 1 and with no Thousands Separators. The confirmatory sample at the bottom of the number settings dialog box says (55556), which seems fine. And the formula produces what I want when read the report through the Crystal 9 preview screen or, indeed, Jeff-Net Report Runner Extended and ePortfolio Lite when they read the file - provided'/b] data is 'saved with the file'. So far so good.
However, when I 'refresh' the report using either Report Runner Extended or ePortfolio Lite, I start to get the year coming up as 2,003.00. This not only looks daft but throws the record groupings awry (i.e. they all become "Others"
. I changed the Windows 2000 Regional Options Numbers settings to 0 Decimal Places and no Digit Grouping (although the machine did insist on a Digit Grouping Symbol). Despite this, the machine persists in putting in a Digit Grouping Symbol (e.g. 2,003) on my Crystal report as seen through Report Runner and ePortfolio Lite, so I have temporarily resorted to using a <space> character in Regional Options. This doesn't help when I turn to MS Excel which now won't show digit grouping commas any more (because I've told Regional Options not to, of course).
Has anyone come across this glitch before? Is it Crystal or a (screen? printer?) driver problem? And am I missing something simple or obvious?
It's not the end of the world, clearly, if I can't fix it but it would be nice to show a correct report.
Nick Stiven
If {pupil.entryterm} = "SU " then "SUM " + ToText({pupil.entryyear})
The Crystal File/Options/Fields/Numbers/Number settings are Decimals to 1 and Rounding to 1 and with no Thousands Separators. The confirmatory sample at the bottom of the number settings dialog box says (55556), which seems fine. And the formula produces what I want when read the report through the Crystal 9 preview screen or, indeed, Jeff-Net Report Runner Extended and ePortfolio Lite when they read the file - provided'/b] data is 'saved with the file'. So far so good.
However, when I 'refresh' the report using either Report Runner Extended or ePortfolio Lite, I start to get the year coming up as 2,003.00. This not only looks daft but throws the record groupings awry (i.e. they all become "Others"
. I changed the Windows 2000 Regional Options Numbers settings to 0 Decimal Places and no Digit Grouping (although the machine did insist on a Digit Grouping Symbol). Despite this, the machine persists in putting in a Digit Grouping Symbol (e.g. 2,003) on my Crystal report as seen through Report Runner and ePortfolio Lite, so I have temporarily resorted to using a <space> character in Regional Options. This doesn't help when I turn to MS Excel which now won't show digit grouping commas any more (because I've told Regional Options not to, of course).Has anyone come across this glitch before? Is it Crystal or a (screen? printer?) driver problem? And am I missing something simple or obvious?
It's not the end of the world, clearly, if I can't fix it but it would be nice to show a correct report.
Nick Stiven