p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: ID10T Question


Message #1 by stephen.scott@a... on Tue, 18 Feb 2003 09:33:37
Stupid question I am sure, but what pray tell, is the answer?

I have been trying to use the formula section of crystal, but it keeps 
telling me that a number is required after the *. 

This is my latest defeat:
   {#RTotal0}*{vw_RptTransactions.FundPrice}

Cystal places the cursor after the astrix and tells me it needs a number. 
Both fields are currency fields! It is just a simple multiplication, and 
the answer is vital to my report. 

Please let me know if you know what I am doing wrong. It will save both 
my head and my office wall alot of pain.

Regards
Stephen
Message #2 by Dheeraj Singh <Dheeraj.Singh@b...> on Tue, 18 Feb 2003 11:35:45 +0200
covert the fields to number using ToNumber

-----Original Message-----
From: stephen.scott@a... [mailto:stephen.scott@a...]
Sent: Tuesday, February 18, 2003 11:34 AM
To: crystal_reports
Subject: [crystal_reports] ID10T Question


Stupid question I am sure, but what pray tell, is the answer?

I have been trying to use the formula section of crystal, but it keeps 
telling me that a number is required after the *. 

This is my latest defeat:
   {#RTotal0}*{vw_RptTransactions.FundPrice}

Cystal places the cursor after the astrix and tells me it needs a number. 
Both fields are currency fields! It is just a simple multiplication, and 
the answer is vital to my report. 

Please let me know if you know what I am doing wrong. It will save both 
my head and my office wall alot of pain.

Regards
Stephen
Message #3 by Stephen Scott <stephen.scott@a...> on Tue, 18 Feb 2003 12:37:58 +0200
Thank you 

Nice and simple solution, but why should I have to convert a field defined
as currency to a number field? Does Crystal not recognise the SQL currency
type?

Cheers
Stephen

-----Original Message-----
From: Dheeraj Singh [mailto:Dheeraj.Singh@b...]
Sent: Tuesday, February 18, 2003 11:36 AM
To: crystal_reports
Subject: [crystal_reports] RE: ID10T Question


covert the fields to number using ToNumber

-----Original Message-----
From: stephen.scott@a... [mailto:stephen.scott@a...]
Sent: Tuesday, February 18, 2003 11:34 AM
To: crystal_reports
Subject: [crystal_reports] ID10T Question


Stupid question I am sure, but what pray tell, is the answer?

I have been trying to use the formula section of crystal, but it keeps 
telling me that a number is required after the *. 

This is my latest defeat:
   {#RTotal0}*{vw_RptTransactions.FundPrice}

Cystal places the cursor after the astrix and tells me it needs a number. 
Both fields are currency fields! It is just a simple multiplication, and 
the answer is vital to my report. 

Please let me know if you know what I am doing wrong. It will save both 
my head and my office wall alot of pain.

Regards
Stephen



******** Appleton Limited *********

This entire electronic mail message is confidential and is issued for information purposes only to the addressee, being a business
associate of Appleton Limited Reg. No 1999/004031/06 or of its subsidiaries.  The message and attachments if any is subject to
copyright and may not be reproduced in whole or in part without the written permission of Appleton Limited. Opinions and
recommendations contained herein are and must be construed solely as statements of opinion and not statements of fact.  Unless
specifically stated, Appleton Limited gives no warranty, expressed or implied, as to the accuracy, timeliness, completeness, or
fitness for any purpose of any information contained within this e-mail.

***********************************
Message #4 by Teresita Castro <shifis@y...> on Tue, 18 Feb 2003 08:12:18 -0800 (PST)
Something similar happened to me when I was trying to multiplicate quantity * price, and that was because price was currency, I was
using ttx reports and I change the currenty for number or Long I don't remember but after that I can do the multiplication.
All that time I was using Crystal Report 8.0
 stephen.scott@a... wrote:Stupid question I am sure, but what pray tell, is the answer?

I have been trying to use the formula section of crystal, but it keeps 
telling me that a number is required after the *. 

This is my latest defeat:
{#RTotal0}*{vw_RptTransactions.FundPrice}

Cystal places the cursor after the astrix and tells me it needs a number. 
Both fields are currency fields! It is just a simple multiplication, and 
the answer is vital to my report. 

Please let me know if you know what I am doing wrong. It will save both 
my head and my office wall alot of pain.

Regards
Stephen


---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day

  Return to Index