We are using Crystal Report 2011 and BOXI 4.0.
Problem: We have a report that is scheduled to export in PDF format with create Group Trees on export. The Groups by Client ID in format 1234. But when they get exports the group tree displays them as 1,234 and in some reports as 1,234.00. We do not want any commas or decimals. If we schedule these reports in excel, or crystal they are fine.
ramblinrose_55 (BOB member since 2008-03-17)
I work with ‘ramlinrose_55’ and I thought it would be easier to understand the issue with a visual. I’ve attached an image showing the side by side comparison of the format in the report and the format after the export.
If we export from Crystal on our desktop to ‘application’ is shows the formatting correctly. It just seems to be when the server runs the report and exports it the number formatting goes wrong.
MizarKey (BOB member since 2009-12-16)
If all of your numbers are exactly the same number of digits, I would use ToText to format them as string with the following syntax:
ToText({table.numberfield}, ‘’, 0)
If some have fewer digits, you’ll have to add leading zeros to the number in order to get it to sort correctly. If the number is 7 digits, it will look something like this:
Right(‘0000000’ + ToText({table.numberfield},’’,0), 7)
-Dell
hilfy 
(BOB member since 2007-04-16)
Thank you for your reply and we have considered using the ‘totext’ as a work-around. But what I’m hearing is that there’s no Crystal setting that will correct this? Not even some kind of registry entry?
MizarKey (BOB member since 2009-12-16)
No. Unfortunately, they don’t let us have any control over any export format outside of what’s in the scheduling screen or export dialog. This has long been an issue with Crystal as whatever the programmers think is the “right” format isn’t always the best format for everyone. Since this works correctly from Crystal, I would open a case with SAP to see whether they will fix it in a fix pack or service pack for BO 4.x.
-Dell
hilfy (BOB member since 2007-04-16)