Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: I've a problem with a simple operation Post Reply Post New Topic
Author Message
cindolj
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Guatamala
Online Status: Offline
Posts: 1
Quote cindolj Replybullet Topic: I've a problem with a simple operation
    Posted: 14 Oct 2008 at 5:04pm
somebody help me
I've a problen with a simple operation
I create a formula
I tray to multiplay two numeric fields from diferent Tables of Data Base (SQL 2005)
{Table1.Field1} * {Table2.field2}
but when a check the formula I get this message
a number is required here

I don't understand why happend this

I'm using Cristal Report 8.5 and SQL Server Express(2005)

IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 15 Oct 2008 at 5:13am
You get this type of message when trying to do certain operations with different data types i.e. numbers and characters. I'm guessing that one of the fields may have been defined as a character field.

Try the tonumber operation to see if that solves it. Example:

{table1.field1}*tonumber({table2.field2})

Sarah
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 15 Oct 2008 at 6:56am
may be you have null values in your database fields
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.045 seconds.