Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

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
0
Lee Anderson
Asked:
Lee Anderson
1 Solution
 
Accpac_AttackCommented:
Try:
ToText(Member#,"#######") & "-" & ToText(Account#,"#######")
0
 
Lee AndersonVP, CIOAuthor Commented:
Thanks Accpac,

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
0
 
mlmccCommented:
Another way is

ToText(Member#,0,'') & "-" & ToText(Account#,0,'')

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now