Click here to Skip to main content
Rate this: bad
good
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{students.name} = "" then
""
else
"Student Name : " + {students.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
good
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.

Thanks
  Permalink  
Comments
hemantwithu at 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
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2014
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