PC SOFT

WINDEV的在线文档

  • Overview
  • Creating a report on a HFSQL view
  • Printing a report on a HFSQL view
  • To print a report on HFSQL view
  • WinDev example
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

Report on a HFSQL view

Overview
A report on a HFSQL view is used to print records coming from a HFSQL Classic or Client/Server view.

Reminder: A HFSQL view corresponds to a "memory image" of a data file. A view is stored in memory, which insulates it from the modifications made to the associated data file. Once created, a view can be handled like any HFSQL data file. See The HFSQL views for more details.

Characteristics of a report on a HFSQL view:
  • a report on a HFSQL view is linked to the base file of this HFSQL view. The report is used to print the records coming from this base file.
  • the order in which the records are printed corresponds to the order of the records found in the HFSQL view (defined when creating the view or by H视图排序).
The creation of a report on a HyperFileSQL view is performed via the wizard for report creation ("File .. New .. Report").The creation of a report on a HFSQL view is performed via the wizard for report creation.

When the report on a HFSQL view is created, you have the ability to:
  • modify the data source of the report ("Data" tab of the report description).
  • add or delete Item controls linked to the HFSQL view associated with the report.

ImportantReports & Queries cannot be used to create reports on a HFSQL view. However, you have the ability to customize the reports on a HFSQL view created in the standard report editor (color, fonts, size, ...).

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Creating a report on a HFSQL view
To create a report on a HFSQL view:
  1. Select "File .. New .. Report". The wizard for report creation starts.Clickamong the quick access buttons.
    • Click "Report" in the wheel that is displayed.The window for creating a new element is displayed: click "Report" then "Report".
    • The wizard for report creation starts.
  2. Choose the layout of your report (table, form, label, ...). See The different types of reports for more details.
  3. Select (if necessary) the report template to use. A report template is used to comply with a specific page layout. See The report templates for more details.
  4. Select the data source of the report ("Other (programing, text file, memory zone, HyperFileSQL view, ...").Select the data source of the report ("Other (programming, text file, memory zone, HFSQL view, ...").
  5. Select the type of data source for the report ("From a HyperFileSQL view").Select the type of data source for the report ("From a HFSQL view").
  6. Select the base data file of the HFSQL view associated with the report.
  7. Select the items displayed in the report. Only the controls linked to the items of the HFSQL view will be filled.
    For each item displayed in the report:
    • enter the corresponding caption. This caption will be displayed:
      • before the item. For example:
      • in the header of the column (for the Table reports). For example:
        This caption can be modified in the report editor.
    • select the block where the control associated with the item must be printed. The positions of the different controls can be modified in the report editor. See Report blocks for more details.
  8. Modify (if necessary) the display order of the controls in the report with the arrow buttons found on the right of the table.
  9. If the HFSQL view associated with the report contains at least one numeric item, you have the ability to perform calculations these items. Specify the calculation performed for each item (sum, average, ...). Two types of calculations are available:
    • general calculation: a Calculated control will be created in the End of document block.
    • calculation on break (useless in this type of report).
  10. Depending on the type of report currently created, indicate the specific options.
    Type of reportSpecific options
    Type of report: Table + ChartType of the chart, aspect of the chart, ...
    Options presented in details in Table + Chart report
    Chart reportType of the chart, aspect of the chart, ...
    Options presented in details in Chart report
    Report on formImage of the form, print the image of the form, ...
    Options presented in Report on form
    Label reportFormat of labels, number of identical copies, ...
    Options presented in Label report

    Type of reportSpecific options
    Report on formImage of the form, print the image of the form, ...
    Options presented in details in Report on form
    Label reportFormat of labels, number of identical copies, ...
    Options presented in Label report
  11. Specify the format of the sheet on which the report will be printed. The report is printed in A4 format by default.
    Note: By default, the report controls are displayed in a single column. To create a multi-column report, the requested number of columns must be specified in the "Format" tab of the description window of the report.
  12. Select the skin template of the report if necessary.
  13. Enter the name and title of the report (name of the ".WDE" file corresponding to the report). This name will be used to identify the report in your programs.
    WinDev You also have the ability to specify whether the report can be modified by the end user in "Reports & Queries".
  14. Validate the report creation.
  15. The report editor automatically proposes to change the format of the report if the following conditions are fulfilled:
    • the report currently created includes a table.
    • the report format does not allow to display all the table columns.
  16. Specify (if necessary) the mode for reducing the report size:
    • 19版本和更高版本
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
      19新版本
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
    • Use the landscape mode.
    • Reduce the size of the report. Caution: according to the reduction percentage, the printed report may become unreadable.
  17. The report currently created is displayed in the report editor.

Printing a report on a HFSQL view

To print a report on HFSQL view

  1. Create the HFSQL view with H创建视图 (or with H合并视图).
  2. Configure the destination of the report print:
  3. Specify the following parameters with 打印报表:
    • the name of the report to print.
    • the name of the HFSQL Classic view used.
Notes:
  • The HFSQL view must be created and initialized before printing the report. Only a HFSQL Classic or Client/Server view can be used.
  • If additional parameters must be passed to the report, these parameters must be specified in 打印报表, after the name of the HFSQL view used. See Report with parameters for more details.
  • ..视图名称 used in the report code allows you to find out and change the HFSQL view associated with the report.
  • ..数据源名称 used in the report code allows you to find out and modify the base data file of the HFSQL view associated with the report.

ImportantIn Reports & Queries, a report can be printed:
  • by starting a print ().
  • by running the report test (or "Code .. Run the report test").by running the report test ().
Therefore, no programming is required to print the report.

WinDev

WinDev example

The user selects the reference of an order in a list. The "BTN_Print" button is used to:In this example, the click code of the "BTN_Print" button is as follows:

// Create the view
如果H创建视图"OrderView"OrdLine"*""Reference""""",...
h视图.独占+h视图.不可中断)=,那么
错误H错误信息())
否则
// Open the preview window
打印预览()
// Print the RPT_View report
打印报表RPT_View"OrderView"
结束