非常规的报告令 [英] unconventional order for a report
问题描述
报告是3页，加上两页报告页脚和
封面页面报告标题。如果三个部门是a，b和c，我可以按升序或降序打印。但是，我会像b-a-c一样模仿excel电子表格这是一个副本
。在我把它们装订之前重新安排论文并不是什么大不了的事，但是当我每季度运行大约20-30份时，它将是
更容易让它按顺序出来。有什么方法可以让我的报告到
选择一个特定的订单？谢谢。
-
Greg
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe /For...ccess/200604/1
一些想法：
如果你有信息，你可以将信息添加到你的部门主文件中。
创建一个可以维护的小表，其中包含报告序列
和部门ID。在你的初始序列中使用10或100，所以
以后可以添加其他部门，而无需重做所有的
。
排序报表时，按此排序顺序排序。如果您使用
不同的表格，请务必允许使用您所使用的部门
没有序列。或者为报告添加一些逻辑准备
验证所有部门都有序列。
您也可以将其硬编码到报告的查询中，但是你必须修改代码，如果他们添加了另一个部门。
如果你向部门主人添加一个字段想想你想要什么
是默认值。你想让新的部门在所有旧部门的前面或者说b
吗？
它几乎不可能将添加任何新部门。在
介意中，如何将其硬编码到查询中？此报告不会显示单个记录，而是每个部门的摘要数据。这是分组
，我想按升序或降序重新排序，只是为了清楚。
Ron2005写道：一些想法：
如果有的话，可以将信息添加到部门主文件中，或者创建一个可以维护的小表其中包含报告序列
和部门ID。在您的初始序列中使用10或100，以便其他部门可以在以后添加，而无需重做所有
当您对报告进行排序时，请按此排序sortsequence。如果您使用不同的表，请确保允许使用您没有序列的部门。或者为报告添加一些逻辑准备
，验证所有部门都有序列。
您也可以将其硬编码到报告的查询中，但是您有
修改代码，如果他们添加了另一个部门。
如果你向部门主人添加一个字段，想想你想要的是什么
作为默认值。您是希望新部门在所有旧部门的前面还是
？
-
Greg
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200604/1
来自AccessMonster.com的
ka******@comcast.net 在消息中写道
< 5e9e721dae7d7 @ uwe> ：很可能不会添加任何新部门。请记住，如何将其硬编码到查询中？本报告
不显示每个部门的个人记录，而是显示每个部门的摘要数据。这是我想要按照升序或降序重新排序的分组，只是为了清楚。
我猜一种方法可以尝试切换功能 - 空气代码 - 请查看
帮助文件中的功能以获取更多信息，或者回复
select< field list>，
开关（[MyDep] =" A"，2，[MyDep] =" B"，1，[MyDep] =" C"，3）as MyOrderBy
来自< yourtables> ;
其中< conditions>
按开关排序（[MyDep] =" A"，2，[MyDep] =" B"，1，[MyDep ] =" C"，3）
-
Roy-Vidar
hey... i have a report whose detail section is based on three departments so
the report is 3 pages for that, plus two pages for a report footer and a
cover page report header. if the three departments are a, b and c, i can get
them to print either in ascending or decending order. however, i would
really like it to be b-a-c to mimic the excel spreadsheet this was a copy
from originally. it''s not THAT big a deal to rearrange the papers before i
staple them, but when i run off about 20-30 copies each quarter, it would be
easier to have it come out in order. is there any way i can get my report to
select a specific order? thanks.
--
Greg
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
Some ideas:
Either add information to your department master file if you have it or
create a small table that can be maintained that has Report sequence
and department ID in it. In your initial sequences use 10 or 100s so
that other departments can be added later without having to redo all of
them.
When you sort for the report, sort by this sortsequence. If you use a
different table, be sure to allow for a department being used that you
do not have a sequence for. or add some logic preparatory to the report
that verifies that all departments have a sequence.
You could also hard code it into the query for the report, but then you
have to modify code if they add another department.
If you add a field to the department master think about what you want
to be the default value. Do you want new departments to be in front or
in back of all the old departments ?
it is HIGHLY unlikely that any new departments will be added. with that in
mind, how do i hard code it into the query? this report doesn''t display
individual records but summary data for each department. it''s the groupings
that i want to re-sort by neither ascending or decending order, just to be
clear.
Ron2005 wrote:Some ideas:
Either add information to your department master file if you have it or
create a small table that can be maintained that has Report sequence
and department ID in it. In your initial sequences use 10 or 100s so
that other departments can be added later without having to redo all of
them.
When you sort for the report, sort by this sortsequence. If you use a
different table, be sure to allow for a department being used that you
do not have a sequence for. or add some logic preparatory to the report
that verifies that all departments have a sequence.
You could also hard code it into the query for the report, but then you
have to modify code if they add another department.
If you add a field to the department master think about what you want
to be the default value. Do you want new departments to be in front or
in back of all the old departments ?
--
Greg
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
ka******@comcast.net via AccessMonster.com wrote in message
<5e9e721dae7d7@uwe> :it is HIGHLY unlikely that any new departments will be added. with
that in mind, how do i hard code it into the query? this report
doesn''t display individual records but summary data for each
department. it''s the groupings that i want to re-sort by neither
ascending or decending order, just to be clear.
I guess one way could be trying the switch function - "air code" - look
up the function in the help files for more info, or post back
select <field list>,
switch([MyDep]="A",2,[MyDep]="B",1,[MyDep]="C",3) as MyOrderBy
from <yourtables>
where <conditions>
Order By switch([MyDep]="A",2,[MyDep]="B",1,[MyDep]="C",3)
--
Roy-Vidar
这篇关于非常规的报告令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
