Grouping an totaling in report

hollydonut

Hi experts,

Need help about report
I want to create a report with group from 2 data item

in sql query, it look like this

SELECT [Item No_],[Variant Code],[Location Code],a.[Dimension Value Code],SUM([Quantity]) as Qty
FROM
[dbo].[Cronus$Item Ledger Entry]
LEFT JOIN
(Select * from [dbo].[Cronus$Ledger Entry Dimension]
Where = 32 and [Dimension Code]='SALESPERSON')a
on [BookHaven UAT$Item Ledger Entry].[Entry No_] = a.[Entry No_]
Group By [Item No_],[Variant Code],[Location Code],a.[Dimension Value Code]

But i cannot figure it out how to link the item ledger entry and Ledger Entry Dimension.

Maximus

Hi,

the link is like this:

In Ledger Entry Dimension Table ID = 21 (Table No. of Customer Ledger Entry Table)

and

Customer Ledger Entry.Entry No. = Ledger Entry Dimension. Entry No.

hollydonut

But how about the grouping?
My problem is not all item ledger entry have dimension that means the entry no will not inside ledger entry dimension right?,
But i want to summarize all of the qty in the item edger entry base on the dimension value, item no, variant no, and location no.