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)
Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
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:
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
IP Logged
