Print Page | Close Window

What is the reason of this error in Crystal Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18322
Printed Date: 20 Apr 2025 at 3:02pm


Topic: What is the reason of this error in Crystal Report
Posted By: hemantwithu
Subject: What is the reason of this error in Crystal Report
Date 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


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window