使用参数访问报告/子报告 [英] Access Report / Sub report with parameters

问题描述

我有一份报告，附有一份子报告，用于

教会的收入/支出报告。我的费用报告是子报告。

我的问题是，当我运行报告时，它会提示我2-3次参加费用报告的

参数。有没有解决这个烦恼的方法？

感谢您的帮助。


Scott


***通过开发人员指南 http://www.developersdex.com 发送***

不要只是参加USENET ......获得奖励！

I have a report with a sub report for an income / expense report for
church. My expense report is the sub report.
My question is, when I run the report, it prompts me 2-3 times for the
parameters of the expense report. Is there a way around this annoyance?
Thank you for your help.

Scott

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

推荐答案

你如何定义这些参数？


" Scott Gorman" < SG *** @ comcast.net>在留言中写道

新闻：41 ********** @ 127.0.0.1 ...

How are you defining these parameters?

"Scott Gorman" <sg***@comcast.net> wrote in message
news:41**********@127.0.0.1...

我有一个报告与
教会的收入/支出报告的子报告。我的费用报告是子报告。
我的问题是，当我运行报告时，它会提示我2-3次查看费用报告的
参数。有没有解决这个烦恼的方法？
感谢您的帮助。

Scott

***通过Developersdex发送 http://www.developersdex.com ***
不要只是参加USENET ......获得奖励for it！

I have a report with a sub report for an income / expense report for
church. My expense report is the sub report.
My question is, when I run the report, it prompts me 2-3 times for the
parameters of the expense report. Is there a way around this annoyance?
Thank you for your help.

Scott

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

在查询中，我有一个包含以下条目的列。


Field- Month （[日期]）

排序 - 表达

标准 - [费用报告月份：1-12：]


我自己运行这个查询，它工作正常。当我在报告中将此查询作为子报告时，问题似乎是

。它目前是

，提醒我2次这个数据。不知道我是怎么改变它的，但是它好了b $ b之前提示我3次。

谢谢，

Scott

***通过开发人员指南 http://www.developersdex.com 发送***

不要只是参加USENET ......获得奖励！

In the query, I have a column with the following entries.

Field- Month([Date])
Sort- Expression
Criteria- [Expense Report for month: 1-12: ]

When I run this query on its own, it works fine. The problem seems to be
when I have this query in my report as a sub report. It currently is
prompting me 2 times for this data. Not sure how I changed it, but it
was prompting me 3 times before.
Thanks,
Scott

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

我建​​议你参加标准行不在查询中。

相反，在主窗体上放置一个文本框以输入所需的月份。

然后使用子窗体的LinkMasterFields和LinkChildFields属性

控制你的过滤。

" Scott Gorman" < SG *** @ comcast.net>在消息中写道

news：41 ********** @ 127.0.0.1 ...

I''d suggest you take the criteria line out of the query.
Instead, put a textbox on your main form to enter the month you want.
Then use the LinkMasterFields and LinkChildFields properties of your subform
control to take care of your filtering.
"Scott Gorman" <sg***@comcast.net> wrote in message
news:41**********@127.0.0.1...

在查询中，我有一个包含以下内容的列参赛作品。

现场 - 月（[日期]）
排序 - 表达
标准 - [费用报告月份：1-12：]

当我自己运行此查询时，它工作正常。当我在报告中将此查询作为子报告时，问题似乎是
。它目前正在提示我2次这个数据。不确定我是怎么改变它的，但是它之前提示我3次。
谢谢，
Scott

***通过Developersdex发送 http://www.developersdex.com ***
不要只参加USENET。 ..得到奖励！

In the query, I have a column with the following entries.

Field- Month([Date])
Sort- Expression
Criteria- [Expense Report for month: 1-12: ]

When I run this query on its own, it works fine. The problem seems to be
when I have this query in my report as a sub report. It currently is
prompting me 2 times for this data. Not sure how I changed it, but it
was prompting me 3 times before.
Thanks,
Scott

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

这篇关于使用参数访问报告/子报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！