Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: blob field or memo feild cannot be used in a formu Post Reply Post New Topic
Author Message
Trooper
Newbie
Newbie
Avatar

Joined: 07 Feb 2008
Location: United States
Online Status: Offline
Posts: 2
Quote Trooper Replybullet Topic: blob field or memo feild cannot be used in a formu
    Posted: 11 Feb 2008 at 7:15am
I am getting an error :
blob field or memo feild cannot be used in a formula  when I use the following formula...I am using CR 8.5 and oracle 10g as the backend.
 
help appreciated.
 
 
if {Query.SOURCE}='PD'
 then iif(ucase(left({Query.BATCHDESC},6))='FISCAL',val(mid({Query.BATCHDESC},8,4)),{Query.CURRENT_YR})
else
 if {Query.SOURCE}='AL'
  then val({Query.CFISCAL_YR_END})
else
 if isnull({Query.MISC_REFERENCE}) or ucase(left({Query.MISC_REFERENCE},6))<>'FISCAL'
   then {Query.NFISCAL_YR_END}  
 else
  val(mid({Query.MISC_REFERENCE},8,4))
thanks,
VJ
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 12 Feb 2008 at 11:09pm
To use a memo field in a formula, you have to create a separate formula that only returns that memo field. Then use this formula in successive formulas.
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>
IP IP Logged
Angie
Newbie
Newbie
Avatar

Joined: 23 Jun 2008
Location: United States
Online Status: Offline
Posts: 2
Quote Angie Replybullet Posted: 23 Jun 2008 at 3:34pm
I read your advice and had attempted to create a formula just for the field that says it's not usable since it's a blob..yada yada but am not quite sure how to go about it.  something like...
 
formula:
{manualheader.description} = 'patient discharged'
 
any suggestions? Confused
Angie
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 23 Jun 2008 at 11:39pm
To use a memo field, just return it in a formula. This tricks CR into into using like a normal field.

formula:
{manualheader.description


I have more tips and tricks for using formulas in your reports in my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
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>
IP IP Logged
Angie
Newbie
Newbie
Avatar

Joined: 23 Jun 2008
Location: United States
Online Status: Offline
Posts: 2
Quote Angie Replybullet Posted: 24 Jun 2008 at 10:39am
Thanks! i think that jogged my memory about another time I had to do that!!  I can't wait to try it : )  thanks again!!
Angie
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.047 seconds.