Report writing environment

 

Applies To: Dynamics CRM 2013

You must have the required development tools and appropriate privileges in Microsoft Dynamics CRM to write and publish a report. Also, make sure you have working knowledge of:

  • The Transact-SQL language and Microsoft SQL Server 2008 R2.

  • Creating Microsoft SQL Server Reporting Services reports using Business Intelligence Development Studio.

  • The Microsoft Dynamics CRM FetchXML language.

The following are required to write a custom report for Microsoft Dynamics CRM:

  • Microsoft SQL Server 2008 Reporting Services or Microsoft SQL Server 2008 R2 Reporting Services. It must be installed on the Microsoft Dynamics CRM server or on a separate reporting server, depending on where reports are being served from.

    System_CAPS_noteNote

    Microsoft Dynamics CRM supports only native mode of deployment of Microsoft SQL Server Reporting Services. If you have deployed Microsoft SQL Server Reporting Services using any other mode, such as SharePoint integration mode, you must uninstall the existing instance of Microsoft SQL Server Reporting Services, and then reinstall it using the native mode.

    For more information about the various deployment modes of Microsoft SQL Server Reporting Services, see Planning a Deployment Mode.

  • Business Intelligence Development Studio. This is a report authoring environment in Visual Studio 2008 that hosts the Report Designer (a component of Microsoft SQL Server Reporting Services). You can install Business Intelligence Development Studio from the Microsoft SQL Server 2008 Setup CD.

  • Microsoft Dynamics CRM Report Authoring Extension. You require this only if you are writing custom fetch-based reports, such as for Microsoft Dynamics CRM Online. It must be installed on the computer where Business Intelligence Development Studio is installed. You can install Microsoft Dynamics CRM Report Authoring Extension from http://go.microsoft.com/fwlink/?LinkId=199124. Alternatively, you can also install it from the BIDSExtension folder in the Microsoft Dynamics CRM Setup DVD.

System_CAPS_noteNote

Microsoft Dynamics CRM Report Authoring Extension is available only in a 32-bit version because Business Intelligence Development Studio is a 32-bit development environment.

For more information about how to set up the environment for writing reports, download the Microsoft Dynamics CRM 2011 Implementation Guide at http://go.microsoft.com/fwlink/?LinkID=200050.

To deploy custom reports to Microsoft Dynamics CRM, you must have a security role assigned to your account that includes the prvPublishRSReport and prvPublishOrgReport HYPERLINK "javascript:toggleInline('23895_2')" \t "_self" \o "Add Reporting Services Reports"  privileges

The following lists the steps for developing custom Microsoft Dynamics CRM reports. You may have to repeat some steps while you develop a report:

  1. Develop a report concept or specification based on what business information is to be displayed.

  2. Decide on the type of report you want to create: SQL-based or Fetch-based. Microsoft Dynamics CRM Online users can only create custom Fetch-based reports.

  3. Download an existing Microsoft Dynamics CRM report definition language (.rdl) file, and modify it or create a new report by using Business Intelligence Development Studio. More information:  Create custom reports using Business Intelligence Development Studio

  4. Create basic report parameters. More information: Use parameters in reports

  5. Specify datasets and filtering criteria for retrieving data:

  6. Define the basic layout of the report, including headers and footers.

  7. Add report items as required based on the report specification. More information: Add report navigation

  8. Preview the report in Microsoft Visual Studio, and resolve any errors. More information: Test and troubleshoot reports

  9. Deploy the report to the reporting server by using Microsoft Dynamics CRM. More information: Publish reports

  10. Run the deployed report to verify.

For more information, see books about how to write reports for Reporting Services, such as “Microsoft SQL Server 2005 Reporting Services” by Brian Larson.

© 2016 Microsoft Corporation. All rights reserved. Copyright

Community Additions

ADD
Show: