VB and Crystal 8.5 Dev edtion

[Tailgun]

I have 2 columns in a database both are set as currency. I am trying to add them together in the report using a formula so they are added in another part of the report. However it keeps telling me one is NUMBER and the other is a string. Any ideas?

This is driving me nuts

 

[synapsevampire]

Right click the fields and select browse data to see what Crystal thinks that they are.

It may be connectivity related, it may be that you need to apply the service pack, could be lots of things, and you may just use a SQL Expression against the database and have the values returned as a single field already summed (database dependent).

-k

 

[Tailgun]

Thanks synapsevampire it thinks one is a string and the other a number even though both are the same in the database. Both are numbers in the db.

As far as service packs are you meaning the VB one I am using 5 the latest. I am not aware of one for 8.5 Crystal Reports.

 

[mpdinosaur]

tailgun;

I just recently found a service pack for CR 8.5. Look for: cr85win_en_sp3 in Crystal's downloads area.

Hope it helps.

-Mike

 

[Mike Lewis]

Tailgun,

I don't know why CR is interpreting one of the values as a string. But, given that that's what it is doing, why don't you just use the ToNumber() function to convert it back again within your formula?

I know that doesn't really solve the problem, but at least it will get you round it. If, at some time in the future (perhaps after you apply a service pack or upgrade to a new version), the number starts showing up as a number, you shouldn't have to alter your formula, as ToNumber() can also take a numeric argument.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[Tailgun]

Thanks Mike that works just fine. However mpdinosaur I can't find cr85win_en_sp3 in Crystal's downloads area.

 

[JEfromCanada]

I recently downloaded an update. It was called cr85mainwin_en.zip (monthly hotfix for December)

 

[JEfromCanada]

I found a link for the SP3 service pack.

The link was:

http://support.businessobjects.com/fix/hot/si75/form.asp?file=cr85win_en_sp3.exe

 

[Tailgun]

Thanks alot JEfromCanada I just downloaded it.

Thanks again