报告上的选项按钮值和日期创建者问题。 [英] Option Button Values and Date Creator Problems on a Report.

问题描述

大家好，


我在报告和数据报告创建者报告中有关于选项按钮值的两个问题。


情况：


我有三个选项值框，两个有3个选项，一个只有两个选项按钮。它们的值为1,2,3。一切都是标准的。现在，当我创建报告时，我只有报告中每条记录的编号，这有点丑陋而且不方便用户使用。有没有机会将这些值转换为实际文本？


例如。值为1的optButton应该收到内部。


我试图用iif克服这个问题，什么都不做。


我有另一个问题。我已经构建了搜索日期创建者报告。基本上，该工具会在用户键入开始日期和结束日期时创建报告。但是，我希望此报告创建者还显示日期从（空）。


这里是代码：

Hi there,

I have a two problems concerning option button values on a report and data report creator reports.

The situation:

I have three option value boxes two have 3 option and one has only two option buttons. They have values 1, 2, 3. Everything is standard. Now when I create the report, I have only the number for each record on the report, which is kind of ugly and not user-friendly. Is there a chance to turn this values into actual text?

For example. optButton with value 1 should receive Internal.

I have tried to overcome the problem with an iif, doesn''t do anything.

Another problem that I have. I have build an "search date creator report". Basically, that tool creates a report when the user types in Start Date and End Date. However, I would like that this report creator also shows Date from to (empty).

Here''s the code:

展开 | 选择 | Wrap | 行号

推荐答案

你好，


我对报表和数据报表创建者报表中的选项按钮值有两个问题。


情况：


我有三个选项值框，两个有3个选项，一个只有两个选项按钮。它们的值为1,2,3。一切都是标准的。现在，当我创建报告时，我只有报告中每条记录的编号，这有点丑陋而且不方便用户使用。有没有机会将这些值转换为实际文本？


例如。值为1的optButton应该收到内部。


我试图用iif克服这个问题，什么都不做。


我有另一个问题。我已经构建了搜索日期创建者报告。基本上，该工具会在用户键入开始日期和结束日期时创建报告。但是，我希望此报告创建者还显示日期从（空）。


这里是代码：

Hi there,

I have a two problems concerning option button values on a report and data report creator reports.

The situation:

I have three option value boxes two have 3 option and one has only two option buttons. They have values 1, 2, 3. Everything is standard. Now when I create the report, I have only the number for each record on the report, which is kind of ugly and not user-friendly. Is there a chance to turn this values into actual text?

For example. optButton with value 1 should receive Internal.

I have tried to overcome the problem with an iif, doesn''t do anything.

Another problem that I have. I have build an "search date creator report". Basically, that tool creates a report when the user types in Start Date and End Date. However, I would like that this report creator also shows Date from to (empty).

Here''s the code:

展开 | 选择 | Wrap | 行号

萨莎。


我猜测OptionGroup控件绑定到表中存储数值的某个字段。你需要建一个表


tblOptions

keyOptionID Long，PK（OptionGroup.Value）

txtOption Text（要替换的文本） OptionGroupValue）


用适当的Number-Text对填充表格

构建一个基于rptDateParameterReport.RecordSource表的查询/查询到tblOptions联接并设置查询到rptDateParameterReport.RecordSource。


现在你可以在rptDateParameterReport中将对应控件的ControlSource设置为tblOptions.txtOption


祝你好运。

Hi, Sacha.

I guess the OptionGroup control is bound to some field in a table where it stores numerical values. You need to build a table

tblOptions
keyOptionID Long, PK (OptionGroup.Value)
txtOption Text (Text to replace OptionGroupValue)

fill the table with an appropriate Number-Text couples
build a query based on rptDateParameterReport.RecordSource table/query to tblOptions join and set the query to rptDateParameterReport.RecordSource.

Now you can set ControlSource of a correspondent control in rptDateParameterReport to tblOptions.txtOption

Good luck.

再一次，感谢你的帮助，我解决了第一个问题。


你知道吗，我怎么能改变这是我的SQL-Query的一部分，所以可选使用Date to？

Once again, thanks to your help, I solved the first problem.

do you know, how I could change this WHERE part of my SQL-Query, so that it is optional to use "Date to"?

展开 | 选择 < span class =codeDivider> | Wrap | 行号

再次感谢您的帮助，我解决了第一个问题。


你知道吗，我怎么能改变我的SQL-Query的WHERE部分，以便可选来使用日期到？

Once again, thanks to your help, I solved the first problem.

do you know, how I could change this WHERE part of my SQL-Query, so that it is optional to use "Date to"?

展开 | 选择 < span class =codeDivider> | Wrap | 行号

这篇关于报告上的选项按钮值和日期创建者问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！