You are a Microsoft Dynamics CRM system administrator. You are responsible for creating custom reports for Microsoft Dynamics CRM.
Your manager asks you to create a Transact-SQL custom report for opportunity records. The report must work in Microsoft Dynamics CRM on one or multiple opportunity records as determined by the individual who runs the report.
Which two options should you use to create the report? Each correct answer represents a complete solution.
A. Microsoft SQL Server Data Tools
B. Microsoft SQL Server Reporting Services
C. report publisher
D. Microsoft ODBC Driver for SQL Server
