Compare variable's value in crystal......

I tried to wrote same formula in 2 different ways but unfortunately it didn't run.
It gives me below mentioned error when i try to preview my report.

1)Error: Numeric Overflow.

StringVar X;
If {table_site.x_site_group} = "Bldg" then
    X := chr({table_site.objid})
Else If {table_site.x_site_group} = "Tenant" then
    If chr({table_site.child_site2site}) = X then
        {table_site.name}
    Else
        ""
Else
    ""

2)Error:The String is non-numeric.

StringVar X;
If {table_site.x_site_group} = "Bldg" then
    X := chr({table_site.objid})
Else If {table_site.x_site_group} = "Tenant" then
    If {table_site.child_site2site} = ToNumber(X) then
        {table_site.name}
    Else
        ""
Else
    ""

Let me know as soon as you can.


Thanks for your time in advance.

Thanks,
bhavesh55
bhavesh55Asked:
Who is Participating?
 
StingRaYConnect With a Mentor Commented:
Try this...
StringVar X;
If {table_site.x_site_group} = "Bldg" then
    X := ToText({table_site.objid},0)
Else If {table_site.x_site_group} = "Tenant" then
    If ToText({table_site.child_site2site},0) = X then
        {table_site.name}
    Else
        "" 
Else
    "" 
0
 
bruintjeCommented:
is this C++?

could you see what's in X after the line

X := chr({table_site.objid})

maybe in a message or something?
0
 
jfrankieCommented:
The `chr` function returns a string containing the character associated with the specified character code.

and you you have to pass a numerique value to that function.

If you want to convert to Character, you should use the str() function.

Hope that help.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
3rsrichardCommented:
behive keeps asking this same question over and over?
0
 
y2kwackoCommented:
Looks like Pascal/Delphi to me based on the := portion
0
 
bhavesh55Author Commented:
All Experts
I am talking about "Crystal Report ver. 8.0".

Please let me know as soon as you can.

Thanks for your time in advance.

Thanks,
bhavesh55
0
 
bhavesh55Author Commented:
Fields in Sql-server Database:

x_site_group , name --> char
objid,child_site2site --> int

table_site --> table name

I put above mentioned formula in crystal report's formula editor and i unable to run it successfully.

Please try and let me know i can i fix that.

Thanks,
bhavesh55
0
 
bhavesh55Author Commented:
StingRaY

I wrote below mention code:StringVar X;
If {table_site.x_site_group} = "Bldg" then    X := ToText({table_site.objid},0)
Else If {table_site.x_site_group} = "Tenant" then
    If ToText({table_site.child_site2site},0) = X then        {table_site.name}
    Else        ""Else    ""
It shows me value of "{table_site.objid}".Actually in "Else if" part i wrote
"{table_site.name}".Means if condition is satisfied than it should display
that value.Instead of that it displays me value of "objid".
Let me know how do i resolve this problem.Or whats wrong with it ?
Thanks for your time in advance.I am eagerly waiting for your reply.

Thanks,
bhavesh55
0
 
bhavesh55Author Commented:
StingRaY

I wrote below mention code:StringVar X;
If {table_site.x_site_group} = "Bldg" then    X := ToText({table_site.objid},0)
Else If {table_site.x_site_group} = "Tenant" then
    If ToText({table_site.child_site2site},0) = X then        {table_site.name}
    Else        ""Else    ""
It shows me value of "{table_site.objid}".Actually in "Else if" part i wrote
"{table_site.name}".Means if condition is satisfied than it should display
that value.Instead of that it displays most of the time value of "objid" and sometimes "name".
Let me know how do i resolve this problem.Or whats wrong with it ?
Thanks for your time in advance.I am eagerly waiting for your reply.

Thanks,
bhavesh55
0
 
bhavesh55Author Commented:
StingRaY
Above ones is not properly shown so i resubmit the same one.

I wrote below mention code:

StringVar X;
If {table_site.x_site_group} = "Bldg" then
    X := ToText({table_site.objid},0)
Else If {table_site.x_site_group} = "Tenant" then
    If ToText({table_site.child_site2site},0) = X then
       {table_site.name}
    Else    
         ""
Else    ""

It shows me value of "{table_site.objid}".Actually in "Else if" part i wrote
"{table_site.name}".Means if condition is satisfied than it should display
that value.Instead of that it displays most of the time value of "objid" and sometimes "name".

Let me know how do i resolve this problem.Or whats wrong with it ?
 
Thanks for your time in advance.I am eagerly waiting for your reply.

Thanks,
bhavesh55
0
 
StingRaYCommented:
bhavesh55

StringVar X := ToText({table_site.objid},0);
If {table_site.x_site_group} = "Bldg" then
     X
Else If {table_site.x_site_group} = "Tenant" then
    If ToText({table_site.child_site2site},0) = X then
        {table_site.name}
    Else
        "" 
Else
    "";

At the first, I assign value of "objid" to X.
if x_site_group is "Bldg", yes it will return X.
if not...but is "Tenant", yes check if value is satisfied then return Site Name
unsatisfied the return "" (zero-length string)
other x_site_group will return "" (zero-length string)

Sorry, English language is not my native language, mine is Thai. I will apologise you if I mis-understand your question.

Happy with programming ^_^
0
 
bhavesh55Author Commented:
You didn't understand my question properly.

Anyway, i will give you points for your help.

Thanks,
bhavesh55
0
 
bhavesh55Author Commented:
StingRaY
You didn't understand my question properly.

Anyway, i will give you points for your help.

Thanks,
bhavesh55
0
 
StingRaYCommented:
bhavesh55
Thank you for given score.
Email me with more information about your question.
This will not impact the score...
....
StingRaY
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.