CR8 not displaying decimals properly 1

[kunai]

Hi,

Got a little problem, can't figure out how to fix it.

I have a table field as 'float' and with value 0.635642
When i display this field in CR8 report, it shows only 0.63
(It's like that when i browse the field values withing the report)

When used in a calculation, the correct value of 0.635642 is used, not 0.63.

How can i show the whole value of the field?
Using CR8 with VB6 with MS Sql database.

Thanks for any suggestions

 

[synapsevampire]

Perhasp the formatting of these fields is et to 2 decimals?

Right click the field and select Format Field->Number->Customize and change the decimals and rounding to the appropriate level.

If that doesn't resolve, try using a SQL Expression and CAST it as a numeric or some such and see if that resolves.

You might also try changing the connectivity type from ODBC to Native or vice-versa.

Native is the fastest.

-k

 

[kunai]

Yeah formatting it would work.. but i'm using my field in a Formula Field. I can't format it directly.
Sorry, forgot to mention that.

Is there a function like Format()?

 

[synapsevampire]

Share the formula that you intend to use it with.

Why are you using a formula field?

If you're trying to gang it into a formula for display purposes, don't bother, just drop whatever fields you need into a single text object along with any manually entered text.

If this doesn't work, please post the complete intent.

-k

 

[kunai]

Formula:
({table.amount}/{table.xRate}) & " CAD @ " & {table.xRate}

I'm trying to get the output to be something like:
"$350.55 CAD @ 0.76524"

I just used two fields to get it to work. It just doesn't align properly.

Guess it's better than nothing.

Thanks for you help.

 

[kunai]

Dropping the fields into a text box... forgot that could be done. duh!

Thanks!