Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: formula Post Reply Post New Topic
Author Message
abul71
Newbie
Newbie
Avatar

Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 8
Quote abul71 Replybullet Topic: formula
    Posted: 24 Jan 2008 at 11:44am
 
Hi
I an almost new in crystal report. Below is a Formula that i get it from web. In this Formula, there is a variable named formula. i don't know where this variable "formula" comming from. is it a built in keyword?.  please help me.
 
thanks
 
Dim s As String
s = Group({Orders.Order Date}, "monthly")
If IsDate(s) Then  
     formula = CDate(s)

Else

     formula = CDate(0,0,0)

IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 24 Jan 2008 at 10:22pm
hi
in the crystal formula editor there are two options. one is the "crystal syntax" and the other one is "basic syntax". if u select the "crystal syntax" then you wont get the string "formula = ", but if u select the "basic syntax" then u get the string "formua = ".
by default the selection is "crystal syntax", please check this in your report.
Thanks
Savan
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 24 Jan 2008 at 10:31pm
I would like to add one thing to maybe clarify. This formula is written in Basic syntax and your report has Crystal syntax selected. It gives the error because the two syntaxes aren't compatible. So if you switch your language to Basic syntax, then the error should go away and everything should be fine.
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
abul71
Newbie
Newbie
Avatar

Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 8
Quote abul71 Replybullet Posted: 25 Jan 2008 at 10:06am
thanks guys.
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.015 seconds.