Print Page | Close Window

I've a problem with a simple operation Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4538 Printed Date: 27 Apr 2024 at 1:19am Topic: I've a problem with a simple operation Posted By: cindolj Subject: I've a problem with a simple operation Date 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) Replies: Posted By: saoco77 Date 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 Posted By: qasimali84 Date Posted: 15 Oct 2008 at 6:56am may be you have null values in your database fields

Print Page | Close Window