使用OpenReport过滤循环 [英] Filter Loop with OpenReport

问题描述

使用下面的代码，我正在尝试过滤Temp Table中每个记录集的1个报告。该报告从查询运营商报告中过滤掉。

展开 | 选择 | Wrap | 行号

解决方案

我猜它是你发送变量rs的方式。尝试将其从引文中取出，这样看起来就像这样。

展开 | 选择 | Wrap | 行号

Marc'上正确的线条，但代码有点破碎，而不仅仅是看起来。您还需要从 rs 记录集中提供一些值，并且需要将其包含在数据类型的相关字符中。 rs 的引用本身只是指向一个不可用的记录集对象。必须指定其中一个属性。

当我输入您的代码时，我现在得到一个类型不匹配。错误

With my code below, I am trying to filter the 1 report for each record set in the "Temp Table". The report is filtered from a query "Carrier Report".

Expand|Select|Wrap|Line Numbers

解决方案

I would guess it''s how you are sending over the variable rs. Try taking it out of the quotations so it would look like this.

Expand|Select|Wrap|Line Numbers

Marc''s on the right lines but the code''s a bit more broken than just that it seems. You also need to provide some value from your rs recordset and it needs to be surrounded by the relevant characters for the type of data. A reference of rs on its own simply points to a recordset object which is unusable. One of the properties must be specified.

When I enter your code, I am now getting a "Type Mismatch" error

这篇关于使用OpenReport过滤循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！