Step 1: create new report view
Step 2: define report view columns
DocStatus
Function Column: DocStatus
QtyOrdered
Function Column: SUM(@)
SQL Group Function = true
if we try to run the report, following exception is thrown: column "rv_orderdetail.docstatus" must appear in the GROUP BY clause or be used in an aggregate function
column "rv_orderdetail.docstatus" must appear in the GROUP BY clause or be used in an aggregate function
Step 1: create new report view
Step 2: define report view columns
DocStatus
Function Column: DocStatus
QtyOrdered
Function Column: SUM(@)
SQL Group Function = true
if we try to run the report, following exception is thrown:
column "rv_orderdetail.docstatus" must appear in the GROUP BY clause or be used in an aggregate function