Question: I have created a query in AOT with SalesLine as the Main Datasource and CustInvoiceTrans as DataSource under SalesLine.I have given OuterJoin as Join Mode. Now I am trying to develop SSRS Report as follows:

SalesId ItemId OrderedQty RemainingQty InvoicedQty InvoiceId InvoiceDate

My Requirement is to display All SalesOrders in the given Range and also their Respective InvoiceIds and Dates if Invoiced and if not Invoiced their recpective InvoiceIds and Dates as Null.

Kindly help me out in cracking the challenge.

Answer: 
In addition to the recommendations above, looking at the relations on the CustInvoiceTrans table in the AOT should show you a link between SalesLine on the InventTransId field. With this, it's a pretty simple query:

While select SalesLine
 where SalesLine.ItemId = 'AnItemId'
 outer join CustInvoiceTrans
 where CustInvoiceTrans.InventTransId ==  

 SalesLine.InventTransId
 {
 //build your report data source here
 }

Sorry for the formatting, typing this from my phone. The above example will filter the SalesLine table for all records containing the item specified. You'll probably need to refine the logic to get what you need, but it's a start.
It seems you need some basic reporting skills, but [lets do some googling first](https://www.google.com/search?q=AX%202012%20SSRS%20report) to help you out:

* [Reporting in Dynamics AX](http://technet.microsoft.com/en-us/library/ee873263.aspx)
* [Create Quick first SSRS report in Dynamics AX 2012](http://dynamicsaxgyan.wordpress.com/2011/08/19/learn-quick-first-ssrs-report-in-dynamics-ax-2012/)
* [Developing SSRS report using Query in Microsoft Dynamics AX 2012](https://community.dynamics.com/ax/b/dynamics101trainingcenterax/archive/2013/07/10/developing-ssrs-report-using-query-in-microsoft-dynamics-ax-2012.aspx)

If you are more of a visual guy there is [a youtube channel](https://www.youtube.com/user/dynamicsaxbi) to keep you going for hours.