Click here to Skip to main content
13,409,770 members (38,286 online)
Rate this:
Please Sign up or sign in to vote.
Hi All,

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{} = "" then
"Student Name : " + {}

I have googled alot but no use.Can any one help me regarding this ?
Posted 12-Dec-12 19:09pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

This has to do with your sql connection provider in the report. I remember I had something similar sometime back. The way i fixed it is:

Take a backup of your original report before you do this.

1) Open report
2) Field Explorer --> Database fields
3) Right click and select Set Datasource connection.
3) Add a New connection and Select OLE DB provider as SQL Native Client 10.0
4) replace existing connection with new one.
5) Save the report and Click Verify Database.
6) Delete old connection.

Then try.

If that doesnt fix it tell me. Infact either ways tell me.

hemantwithu 20-Dec-12 0:32am
I have tried as you have mentioned but no use :-(. Any other way

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.180221.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100