Crystal Reports中出现此错误的原因是什么？ [英] What is the reason of this error in Crystal Reports?

问题描述

大家好，





我的水晶报告有问题。我有一个报告，其中四个表绑定为在这4个表中，在公式字段中使用了一个表数据库字段。当我在报表上设置该公式字段时，我收到错误此错误预览报表中的未知数据库连接器错误。



假设当我删除该字段或评论该字段的公式代码时，我们不认为会出现该错误。我也不理解该错误。



我在公式字段中这样写了

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 ?

推荐答案

这必须在报告中使用您的SQL连接提供程序。我记得有一段时间我有类似的东西。我修复它的方式是：



在你这样做之前备份原始报告。



）公开报告

2）Field Explorer - >数据库字段

3）右键单击并选择Set Datasource connection。

3）添加新连接并选择OLE DB提供程序作为SQL Native Client 10.0

4）用新的连接替换现有连接。

5）保存报告并单击验证数据库。

6）删除旧连接。



然后试试。



如果不解决它，请告诉我。事实上，要么告诉我。



谢谢

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

这篇关于Crystal Reports中出现此错误的原因是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！