Crystal Reports - Failed to open a rowset

2019-04-20 02:58发布

What can be done to resolve the exception:

CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open a rowset.

12条回答
劫难
2楼-- · 2019-04-20 03:36

Every time you add a new table in crystal it adds its own links on already linked tables, some times it even links the 2 fields from the same table. Make sure you know your links in order to go through after you add a table and scroll all tables to see for any links create from to the same table

查看更多
不美不萌又怎样
3楼-- · 2019-04-20 03:39

I have also gone through same error with report having sub reports. Issue resolved as i switch to each sub report and make it verify again with database/tables/views.

查看更多
爱情/是我丢掉的垃圾
4楼-- · 2019-04-20 03:39

When you verify your database it might tell you that it is up to date, in that case you have two more options to check for:

a) Refreshing the report (a lightning-shaped icon), if you have a problem with a field, such as a SQL Field, it will give you the error and then show you the edit window for the field.

b) Running the query directly on SQL, if there is a problem with the query itself you will also get this message in Crystal but SQL will tell you exactly what went wrong.

查看更多
Ridiculous、
5楼-- · 2019-04-20 03:39

For me, the problem was fixed when I logged of and logged back to the SQL server that the report was connecting to

查看更多
小情绪 Triste *
6楼-- · 2019-04-20 03:42

I had the same issue, and received this error message:

One ore more fields could not be found in the result set. Use Verify Database to update the report. Error in File filename {9FEE6406-1613-409A-B9BD-C5FDA24E3DEE}.rpt:

The rowset column could not be found.

I was using a stored procedure to collect data for the report, and sure enough I was passing an invalid parameter for the SP. Double check the type and value of the parameters if you are using a SP to populate the report data.

Good luck!

查看更多
贪生不怕死
7楼-- · 2019-04-20 03:45

I received :

CrystalDecisions.CrystalReports.Engine.InternalException was unhandled Message=The Report Application Server failed

Google brought me here. For those that have similar problems.

For the record: I had a byte[] array with an image and removed the log from the report and the error stopped. I now have to figure out what I have done wrong with the logo.

查看更多
登录 后发表回答