Joined: 29 Oct 2008
Online Status: Offline
Posts: 7
Topic: unable to return numbers in crystal repor Posted: 29 Oct 2008 at 4:09am
I am trying to return numerical values such as sum({StudPerformance.Score}) in crystal report formula but am getting the error
A string is required here. Error in File
C:\DOCUME~1\ROOPAN~1\LOCALS~1\Temp\Tick5
{5BEF0273-EA00-4D0D-9D3C-3FB5EC0C177B}.rpt: Error in formula . ' ' A string
is required here.
I am unable to convert sum value to text by using ToText(sum({StudPerformance.Score}) ) as it is returning an error. Could any one suggest Thank you,
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 29 Oct 2008 at 10:50am
The error is generally associated with If-Then statements in a formula where one test returns a number and the other test returns true. Thus, you are two different data types being returned by a single formula. This causes an error. Are you using this in a formula? If so, please list the entire formula here so we can review it.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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
