Get Products with orders via Orders in MCRM 2011

(0) Share

Report

Posted on by Albert_

450

HI All there
Thank you for this community
I have got a question.I have installed Microsoft Dynamic CRM 2011 ( Self-Hosted)
I wanna make a report from orders, ( In Sql Server BI Developer 2008 R2) that gives all products that someone has ordered.
I mean orders of somebody with its related ordered products.
I googled and Binged! alot, but no Success.
I saw this :
http://blog.datixinc.com/blog/reporting-revenue-product-type-microsoft-dynamics-crm
And also this :
https://docs.microsoft.com/en-us/sql/reporting-services/lesson-3-defining-a-dataset-for-the-table-report-reporting-services
In the second link it has gave a query( In chapter 3 ) that does not work cause :
1-The fields and tables does not exist in my DB.
2-The 2008 R2 Dataset does not accept T-SQL Command. ( It seems )
And also lots of links does not worked for me.