RFQFORM Crystal Question

Yahoo Archive
1
For whatever reason, every .dbf report converts numbers to text. It makes it quite a pain to change anything (is that the reason???).

Troy Funte
Liberty Electronics
----- Original Message -----
From: Todd Caughey
To: 'vantage@egroups.com'
Sent: Friday, January 12, 2001 11:53 AM
Subject: [Vantage] RFQFORM Crystal Question


I'm tweaking the request for quote form in Crystal and have come across
something I can't explain (not the first time). Perhaps a Vantage/Crystal
expert out there can shed light on it.

The Quantity field in the RFQQty table is a numeric field with two decimal
positions. I am trying to have it print just the integer portion since we
mostly fax these and I don't want extra zeros in case the tiny decimal point
is lost (100% of what we order is whole units). The Crystal .dbf table
carries this field as a text string so somewhere it got converted. I can
deal with the string manipulation to find the decimal point and strip off
from there rightward but it leaves me wondering why they made it a string in
the first place? To save file space or make it run faster or.....? Just
curious but thought I might learn something if someone knew why.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
2
I'm tweaking the request for quote form in Crystal and have come across
something I can't explain (not the first time). Perhaps a Vantage/Crystal
expert out there can shed light on it.

The Quantity field in the RFQQty table is a numeric field with two decimal
positions. I am trying to have it print just the integer portion since we
mostly fax these and I don't want extra zeros in case the tiny decimal point
is lost (100% of what we order is whole units). The Crystal .dbf table
carries this field as a text string so somewhere it got converted. I can
deal with the string manipulation to find the decimal point and strip off
from there rightward but it leaves me wondering why they made it a string in
the first place? To save file space or make it run faster or.....? Just
curious but thought I might learn something if someone knew why.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
At 02:53 PM 1/12/2001 , you wrote:
>carries this field as a text string so somewhere it got converted. I can
>deal with the string manipulation to find the decimal point and strip off
>from there rightward

Might be easier to use the ToNumber() function. Then you can use the
regular numeric formatting tricks.

>but it leaves me wondering why they made it a string in
>the first place? To save file space or make it run faster or.....? Just
>curious but thought I might learn something if someone knew why.

I think they flip a coin to decide data type conversions, as well as which
fields to exclude from the export!

-Wayne