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…

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 presents part of the solution.