Converting Access qury to a report on AX database

Finance and Operations/AX Technical Forum
1

Hi all,

I am currently wroking on converting access datbase query to an SSRs report on ax database.the query looks something like this

SELECT dbo_INVENTTRANS.ITEMID, dbo_INVENTTABLE.ITEMNAME, Calendar.Week, [Inventory Transaction Type].[Transaction Type], Sum(dbo_INVENTTRANS.QTY) AS SumOfQTY
FROM (Calendar INNER JOIN ([Inventory Transaction Type] RIGHT JOIN (dbo_INVENTTRANS INNER JOIN dbo_INVENTTABLE ON dbo_INVENTTRANS.ITEMID = dbo_INVENTTABLE.ITEMID) ON [Inventory Transaction Type].TRANSTYPE = dbo_INVENTTRANS.TRANSTYPE) ON Calendar.Date = dbo_INVENTTRANS.DATEPHYSICAL) INNER JOIN [C-Pack Items] ON dbo_INVENTTRANS.ITEMID = [C-Pack Items].Item
GROUP BY dbo_INVENTTRANS.ITEMID, dbo_INVENTTABLE.ITEMNAME, Calendar.Week, [Inventory Transaction Type].[Transaction Type], Calendar.Year
HAVING (((Calendar.Week)=[Enter req’d week]) AND ((Calendar.Year)=[Enter req’d year]));

but the tables like calender does not exist in Ax database.Please advise.

thanks,

siri