使用向导创建新的报表 --王茜翻译

使用向导创建新的报表
Create New Reports by Using Wizards

这一章通过一个简单的范例描述了如何创建一个新的报表，以及如何在Lotus Notes中撰写一个Formula以使Lotus Notes客户端使用这个报表。
In this chapter, a simple example is given to illustrate how to create a new report, and how to write a Formula in Lotus Notes in order to use this report at the client-side of Lotus Notes.

在开始工作之前，你需要正确地安装并配置了AluxReport，请参见“安装和配置”
在任何时候，你可以按F1键来寻求帮助。关于如何查找帮助信息，请参见“Getting Help”
Before starting, make sure that you have installed and configured AluxReport properly. See "Installation and Configuration" for reference.
You can ask for help at any time by pressing F1. See "Getting Help" For information on how to search for help.

注释：本章中的范例数据来自于AR_Example_Sales.nsf，你可以在你的Notes Data目录的AR_DB文件夹中找到它。
Note: example data in this chapter are from AR_Example_Sales.nsf, which you can find in the Ar_DB file folder in your Notes Data directory.

这个范例将建立一个查询（Query），从AR_Example_Sales.nsf检索（Retrieve）数据。同时，将示范如何添加一个图表增强报表的显示。
This example will establish a query, and retrieve data from AR_Example_Sales.nsf. At the same time, it will demonstrate how to add a graph to enhance the display of the report.

AluxReport Designer中的“新建向导”有助于轻松快捷地创建报表。向导提供了常用的报表元素（如报表风格、字体选项）供你从列表中选择。向导会根据你的选择协助你建立报表的结构。
"Create New Wizard" in AluxReport Designer helps you create reports easily and quickly. The wizard provides report elements (such as report style options and font options) that are commonly used for you to choose from. The wizard will help you set up the frameset of a report according to your choices.

按照以下步骤，可以在“新建向导”的帮助下创建报表：
You can create a report with the help of "Create New Wizard" in the following steps:

用以下方法之一，打开“新建向导”
· 从菜单栏（Menu bar）中选择File | new…
· 按下CTRL+N键
· 在工具栏上按下“New”按钮
“新建向导” 显示在屏幕中。
Open the "Create New Wizard" in one of the following ways
· Select File | new… from the menu bar
· Press CTRL+N
· Press "New" button in the tool bar
The "Create New Wizard" is displayed on the screen.

向导的首页给出了一些任务提示。单击“Next”
"Notes Selection”对话框（dialog box）显示出来，如下图所示。
Some task prompts are given on the first page of the wizard. Click "Next".
The "Notes Selection" dialog box is displayed as in the following graph.

在Notes Selects对话框中，从Notes TreeView中选择一个服务器，并展开它以显示此服务器上所有数据库的列表。
In the Notes Selects dialogue box, select a server from Notes TreeView and open it to display all database lists on this server.

如果你没有在Notes TreeView中看到你所想要的服务器，在Servers List编辑框（Edit box）中键入服务器的名称如Server/Aluxsoft，并单击“Add”按钮可以增加此服务器到Notes TreeView中，然后从TreeView中选择这个服务器并展开它。
In case you cannot find in Notes TreeView the server you want, enter the name of the server in the edit box of Servers List, such as Server/Aluxsoft, and click "Add" button to add it to the Notes TreeView. Then select this server from TreeView and open it.

选择你想要的数据库并展开它，显示Query和Views项。选择其一，并单击“Next”
Select the database you need and open it, then Query and View will be displayed. Select either of them, and click "Next".

AluxReport包括Views和Query这两种数据检索类型，如果你希望模拟一个已经存在的View从Notes数据库中检索数据，请选择Views并展开它，然后在列出的视图列表中选择你想要模仿的View。如果你想要构建一个特别的查询，请在Notes TreeView中选择Query数据检索类型。
AluxReport includes two types of data retrieval, namely Views and Query. If you wish to simulate an existing View to retrieve data from Notes database, select Views and open it, then select the view you want to simulate from the list of views. If you wish to establish a special query, select Query from Notes TreeView.

模拟View是一种受限的Lotus Notes数据库访问方法。作为一种替代方案，你可以定义一个Query作为更精确、更灵活的数据访问方式。(不同于View， Query是一个AluxReport所特有的特性，而不是Lotus Notes的特性，它在Notes不存在。)
Simulated View is a restrained access mode for Lotus Notes database. As a substitute project, a Query can be defined into a more precise and flexible data access mode. (Different from View, Query is a special feature of AluxReport but not of Lotus Notes. It does not exist in Notes.)

在本例中，在Notes TreeView展开LOCAL服务器并选择“AluxReport Example: Sales”数据库，展开此数据库，从列表中选择Query。
In this example, open a LOCAL server from Notes TreeView and select the "AluxReport Example: Sales" database. Open this database, and select Query from the list.

在接下来的三个对话框窗口中，你需要定义一个详细的查询。
In the following three dialogue boxes, you need to define a detailed query.

· 在“Available Query Fields”窗口中，AluxReport扫描你选择的数据库，并在Available Fields中列出所有的字段。选择你想要的字段，并单击Next
· In the "Available Query Fields" window, AluxReport will scan the database you have selected, and list all fields in the Available Fields. Select the field you want, and click Next.

· 接下来，你可以为每个字段指定更详细的信息，如每个字段的题头（Heading）及长度等。
· Then, you may specify more detailed information for each field, such as the heading and length of each field.

· 最后，你必须为这个查询定义一个数据选择条件。选择条件的语法和Lotus Notes中视图选择公式(View Selection)相同，如Select @All.
· Finally, you must define a data selecting condition for this query. The grammar of the selecting condition must conform to the View Selection Formula of Lotus Notes, such as Select @All.

注意：AluxReport并不效验你设定的选择条件是否正确。
Note: AluxReport will not check the accuracy of the selecting condition you have set up.

在本例中，选择Department、Sales作为这个查询的字段，并保持其它的默认设置。
单击Next，完成Query的定义。
In this example, Department and Sales are selected as the fields of this query, and other default settings are retained. Click Next to finish the definition of Query.

为报表指定一个表达样式（Presentation Style）
Specify a Presentation Style for the report

AluxReport预定义了5种预定义的表达样式，选择不同的表达样式，向导会提示不同的问题。
There are 5 predefined presentation styles in AluxReport. The wizard will prompt different questions for different presentation styles selected.

为简单起见，在本例中，在列表中选择“Tabular”作为表达样式，单击“Next”
To keep it simple, in this example "Tabular" in the list is selected as the presentation style. Click "Next".

为报表指定保存位置
Specify an archival location for the report

AluxReport将保存这个报表设计到你指定的服务器上的设计库（AR_DesingRepository.nsf）中。在Finish对话框窗口中，请从Servers List中选择你存放设计库的服务器。
AluxReport will save this report design to a design repository on the server you have designated (AR_DesingRepository.nsf). In the Finish dialogue box, please select a server from the Servers List to save the design repository.

· 如果你希望的服务器没有出现在列表中，单击“Add”按钮增加你的服务器到列表中，如Server/Aluxsoft。
· If the server you prefer does not appear in the list, click "Add" button to add your server into the list, such as Server/Aluxsoft.
·
· 指定的服务器上必须存在一个名为AR_DesingRepository.nsf的数据库，请参见“配置AluxReport”
· The designated server must include a database named AR_DesingRepository.nsf. See "Configuring AluxReport".
·

在本例中，指定LOCAL作为存放报表设计的服务器，并单击“Finish” 新的报表呈现在布局画板（Layout painter）中。
In this example, LOCAL is designated as the server to save report designs. A new report will be displayed in the Layout painter by clicking "Finish".