Crystal Reports 8.5问题集TEXTSIZE 65534 [英] Crystal Reports 8.5 issue set TEXTSIZE 65534

问题描述

我遇到了Crystal Reports的问题，并试图查看其他人是否遇到过与解决方案类似的问题。

我在使用存储过程获取数据的XP机器上使用Crystal Reports 8.5。存储过程返回行但报告不返回任何行。



在运行存储过程和报告时通过Profiler比较我的SQL跟踪，SQL事件中的此消息

I'm having an issue with Crystal Reports and trying to see if anyone else has encountered similar issue with resolution.
I'm using Crystal Reports 8.5 on a XP machine that uses Stored Procedure to get data. Stored Procedure returns rows but the report doesn't return any rows.

Comparing my SQL Trace through Profiler while running Stored Procedure and the report, this message in SQL Profiler

set TEXTSIZE 65534

脱颖而出。



谷歌搜索时，我找不到具体的解决方案所以我希望有人遇到并解决了这个问题。在此先感谢。

stands out.

While googling, I haven't been able to find a concrete solution so I'm hoping if anyone has encountered and resolved this issue. Thanks in advance.

推荐答案

我能够通过在存储过程中进行更改来解决此问题。我必须尽量减少我使用的内存量。我在存储过程中创建了3个临时表，这些表将在执行结束时被删除。为了解决我的问题，我必须在完成其目的后放弃这些表。不知何故，我怀疑我的报表引擎在此过程中只允许内存中的1个临时表。一旦我在创建另一个临时表之前放下了表，它似乎对我有效。

I was able to resolve this issue by making changes within Stored Procedure. I had to minimize the amount of memory I was using. I had 3 temporary tables created within the stored procedure that would get deleted towards the end of execution. To fix my issue, I had to drop these tables once it fulfilled its purpose. Somehow I suspect that my Report Engine was only allowing 1 temp table in memory during the process. Once I dropped the table right before I created another temp table, it seemed to work for me.

这篇关于Crystal Reports 8.5问题集TEXTSIZE 65534的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！