报告排序顺序和标签 [英] Report Sort order and Labels

问题描述

嗨。


1.报告 rptGrantList 基于我有字段 GrantNo 的表格（文本数据类型） ）按升序排序。但是，我的报告未按升序列出授权号。怎么了？是因为该字段有文本数据类型吗？如果是这样，我怎样才能排序？


2.主要报告 rptECHO 包括3个单独的子报告（ srptAP，srptPay，srptAllocation 的）。并非所有的ECHO都有这些子报告的数据。在这种情况下，我想压制标签。也就是说，而不是显示标签AP费用。和零数据我宁愿不显示标签AP费用一点都不ACCESS 2003有可能吗？


谢谢。

Hi.

1. The report rptGrantList is based on tables where I have the field GrantNo (text data type) sorted to ascending order. However, my report is not listing the grant numbers in an ascending order. What''s wrong? Is it because the field has text data type? If so, how can I get to be sorted?

2. The main report rptECHO include 3 separate sub reports (srptAP, srptPay, srptAllocation). Not all the ECHOs have data for these sub reports. In which case I would like to suppress the labels. That is, instead of showing the label "AP Expenses" and zero data I would rather not to show the label "AP Expenses" at all. Is it possible in ACCESS 2003?

Thanks.

推荐答案

1. 报告定义他们自己的排序顺序，无论输入数据的定义顺序如何。
   
   从查看菜单中查看排序和分组。
2. 我很确定它是。
   
   有一个 On No Data 事件可用于触发将子报告可见性设置为 False的代码或 True 取决于新状态。

1. Reports define their own sort order, regardless of the defined order of the incoming data.
   See Sorting and Grouping from the View menu.
2. I''m pretty sure it is.
   There is an On No Data event which can be used to trigger code setting the subreport visibility to False or True depending on the new state.

对于＃1，您还可以强制报告进行排序由GrantNo使用它的On Load事件。之后可以随时将其重新排序为其他内容。这通常是一个好主意，如果它直接发送到打印机，有多个最终用户无法使用菜单等。

For #1, you can also force the report to sort by GrantNo using it''s On Load event. It can always be re-sorted to something else afterwards. This is usually a good idea if it gets sent straight to a printer, have multiple end users that are clueless with the menus, etc..

展开 | 选择 | Wrap | 行号

@Megalog


我发现这很好奇。


我可以看到排序方式有时可能需要除报告默认排序顺序之外的其他内容，这是一种很好的技术 为了那个原因。我不明白为什么以标准的方式设计排序顺序是最好的，你最容易找到它。我在这里忽略了什么吗？

@Megalog
I found this curious.

I can see that sorting by something other than the reports default sort order may be required sometimes, and this is a good technique to use for that. I can''t see why it would ever be preferable to designing the sort order in the standard way where you can most easily find it again. Am I overlooking something here Mega?

这篇关于报告排序顺序和标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！