如何在报表中按表格显示方式分组? [英] How to group by a table display method in a report?

问题描述

我有一个表CustInvoiceJour.我使用报表通过将某些字段(报表查询中的销售价格，SalesUnit)分组来打印一些信息.报表打印sum(LineDisc)，sum(LineAmount)值.

I have a table CustInvoiceJour. I use report to print some info by grouping some fields (Sales Price, SalesUnit in the report Query. Report prints sum(LineDisc), sum(LineAmount) values.

我想修改报表，然后按字段再添加一个组-但该字段是显示方法. Axapta 3.0仅支持分组的物理字段.

I want to modify report adding one more group by field - but that field is display method. Axapta 3.0 only supports physical fields to group by.

最快的方法是什么?

推荐答案

对不起，但是Axapta 3.0不支持通过显示方法进行分组，也不支持任何其他版本的AX.

Sorry, but Axapta 3.0 does not support grouping by a display method and nor do any other version of AX.

AX 2012支持将计算字段添加到视图，这样可以节省您在该版本中的工作.

AX 2012 support adding a computed field to a view, which would save your day in that version.

在所有其他版本中，您将必须具有一个实字段，然后在插入或更新时计算该字段. 对于CustInvoiceJour表，您只需更改insert方法，因为该表永远不会更新.

In all other version you will have to have a real field, then compute the field on insert or update. For the CustInvoiceJour table you only need to change the insert method, as the table is never updated.

这篇关于如何在报表中按表格显示方式分组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！