Quick Jump Menu
Advanced Search Search the Knowledgebase
Customize sub total for each page and grand total on last page | 每页显示小计,尾页显示总计
Author: Susan Lai Reference Number: AA-00447 Views: 2334 Created: 2014-05-02 23:45 Last Updated: 2014-05-02 23:45 0 Rating/ Voters

Scenario:

Follow the steps to customize sub total for each page and grand total on last page.


Solution:

  1. Go to report designer.
  2. Add a field with the expresssion ictran.amt for subtotal. Double click the field, click “Calculations”, set reset to "End of Page" and select "Sum".
  3. Add one more field with the expression ictran.amt for Grand_Total. Double click the field, click "Calculations", set reset to "End of Report" and select "Sum".
  4. Click “Print When” button, type "ictran.body1" at "Print only when expression is true".

Remark: Put this 2 fields at Page Footer


方案:

以下说明如何订制报表在每一页显示小计,然后在尾页显示总计。


解决方案:

  1. 进入report designer.
  2. 插入ictran.amt字段
  3. 鼠标双击于该字段,按Calculations
  4. 选择End of Page Reset,选择SumCalculate
  5. OK
  6. Print When键,输入ictran.body1Print only when expression is true

备注:把该字段插入于Page Footer

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: