Lee Anderson
asked on
Problem with Crystal Reports Numbers Format
I have a problems with a few reports. I recently upgraded from CE9 to CRS 2008 SP2.
In several of my reports I have a formula that converts to numbers to text and combines them. The formula looks like this:
ToText(Member#) & "-" & ToText(Account#)
to get and value such as 999999-100.
In Crystal Reports 2008, I set my number format to "(1123)" in the Options. The report appears correctly in Crystal Reports 2008.
When I schedule the report in Crystal Reports Server 2008 and export it, it sets the numbers format to "(1,123.00)" so my formula looks like "99,999.00-100.00".
This didn't happen with Crystal Enterprise 9. Can someone give me some guidance as to how I can fix this issue?
Thanks in advance!
Lee
In several of my reports I have a formula that converts to numbers to text and combines them. The formula looks like this:
ToText(Member#) & "-" & ToText(Account#)
to get and value such as 999999-100.
In Crystal Reports 2008, I set my number format to "(1123)" in the Options. The report appears correctly in Crystal Reports 2008.
When I schedule the report in Crystal Reports Server 2008 and export it, it sets the numbers format to "(1,123.00)" so my formula looks like "99,999.00-100.00".
This didn't happen with Crystal Enterprise 9. Can someone give me some guidance as to how I can fix this issue?
Thanks in advance!
Lee
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another way is
ToText(Member#,0,'') & "-" & ToText(Account#,0,'')
mlmcc
ToText(Member#,0,'') & "-" & ToText(Account#,0,'')
mlmcc
ASKER
That fixes the formula. I actually just used, since the numbers expand past the initial #.
ToText(Member#,"#") & "-" & ToText(Account#,"#")
It would be nice if Crystal Reports Server 2008 was able to detect the field formats used in a report when saved from Crystal Reports. This worked without the formulas in Crystal Enterprise 9.
Another issue I found on this report was an issue with charts and group headers. If you are using a number on your chart axis it was displaying the number as 9,999.00 and the same for the Group Header. You actually have to create a group header and axis formula specifically converting the number to text with the formula above.
Thanks,
Lee