Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: What is the reason of this error in Crystal Report Post Reply Post New Topic
Author Message
hemantwithu
Newbie
Newbie
Avatar

Joined: 26 Dec 2012
Location: India
Online Status: Offline
Posts: 1
Quote hemantwithu Replybullet Topic: What is the reason of this error in Crystal Report
    Posted: 26 Dec 2012 at 1:15am
I have a problem with the crystal reports.I have a report in which four tables are bound as source to the tables.In those 4 tables one table database fields are used in the formula fields.When I set that formula field on the report I am getting error this error "Unknown Database Connector Error" in the Preview Report.

Suppose when I remove that field or comment the formula code of that field we are not suppose to get that error.I don't understand that error too.

I have written like this in the formula field
if{students.name} = "" then
else
"Student Name : " + {students.name}



I have googled alot but no use.Can any one help me regarding this ?
Your s
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 Dec 2012 at 3:35am

You don't have anything set between the "then" and "else".  I would change the formula to something like this:

 
if not IsNull({students.name}) and {students.name} <> "" then
"Student Name: " + {students.name}
 
NOTE:  Check for "null" value first - null is NOT the same as a blank string!
 
-Dell
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.031 seconds.