Crystal Reports - 没有为此表，查询或过程返回行集 - 崩溃！

I am using Crystal Reports 8.0.1.0 and have an OLEDB connection set as "favourite". We have several reports being run against a few stored procedures on the database. Our database is an SQLExpress 2005 named instance.

我正在使用Crystal Reports 8.0.1.0并将OLEDB连接设置为“收藏夹”。我们有几个报告针对数据库上的一些存储过程运行。我们的数据库是一个SQLExpress 2005命名实例。

One of the reports deals with balance, i.e. we have to provide a balance report for a specific company or set of companies.

其中一份报告涉及平衡,即我们必须为特定公司或一组公司提供余额报告。

The customer, however, has specifically asked us to have a separate section to be the last one for a specific economic account typology and in order to do this, we have to separate this one from the others which are instead displayed using two parallel subreports.

然而,客户特别要求我们将一个单独的部分作为特定经济账户类型的最后一部分,为了做到这一点,我们必须将其与其他部分分开,而不是使用两个平行的子报告来显示。

Hence our structure should be like follows:

因此,我们的结构应如下所示:

                           GENERAL HEADING
                          PATRIMONIAL STATE
                              ...data...
                           ECONOMIC COUNTS
                              ...data...
                         THIRD-PARTY EFFECTS
                              ...data...

The first two sections below the general heading are achieved with two parallel subreports, so now we have to display the third section. Is it clear up to now? Well, as you may well be aware, CR subreports require you to set the database location, regardless if you have set one up already for main report. The problem, however, is that if I try to set the location pointing to our stored procedure(which returns ALL the data for the balance report), the first time it will display the message in subject, and the second time again, but this time it'll also crash. Our stored procedure has a parameter and both previous subreports(the ones in parallel) are set to the same SP and are working flawlessly.

一般标题下面的前两部分是通过两个平行的子报告实现的,所以现在我们必须显示第三部分。到目前为止是否清楚?好吧,正如您可能知道的那样,CR子报告要求您设置数据库位置,无论您是否已为主报告设置了一个。但问题是,如果我尝试设置指向我们的存储过程的位置(返回余额报告的所有数据),第一次它将在主题中显示消息,第二次再次显示,但是时间它也会崩溃。我们的存储过程有一个参数,两个先前的子报告(并行的)都设置为相同的SP,并且运行正常。

This crash makes it impossible for me to work on the third section and I'm pretty much at loss as to what would be the best approach to solve the issue at hand.

这次崩溃使我无法在第三部分工作,而且我几乎不知道什么是解决手头问题的最佳方法。

Any ideas/suggestions?

I would love to receive your answers and I hope my problem was clear enough(I'm very willing to further delve into it for clarification if ever needed).

我很乐意收到您的答案,我希望我的问题足够清楚(我非常愿意进一步深入研究,以便在需要时进行澄清)。

Thank you so much for your time,

非常感谢您的参与,

Andrea Raimondi

1 个解决方案

#1

Geez... changing the connection from OLEDB to SQLServer it correctly fetches the rowset and doesn't crash!

Geez ...将连接从OLEDB更改为SQLServer,它正确获取行集并且不会崩溃!

I am speechless.

我无语。

Andrew

#1