Skip to Content
Former Member
Apr 03, 2008 at 07:11 AM

Column Totals in user queries


Dear all,

How do i display column totals in user queries at the bottom of the report.

For eg i want to display total quantity sold of a particular item on a particular day, the query will be:

SELECT T1.ItemCode, T1.Quantity FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocDate =[%0] and T1.ItemCode =[%1]

But how do i refine this query to show me at the bottom of the report the total for that item on that particular day