Home > CRM Online, Reports > Create a Simple CRM Online Report in 30 Minutes or Less

Create a Simple CRM Online Report in 30 Minutes or Less

This post assumes you have already installed Business Intelligence Studio (BIDS), which can be installed from the SQL media disc, CRM Report Authoring Extensions, and you have a Report project created in BIDS.

The first step you will take is to create the Report.  Using the report Wizard, right-click the Report project folder in BIDS.

image

The Report Wizard will open unless you previously selected not to use it.  Select Next

image

On the next screen give the Data Source a relevant name, select a Type = Microsoft Dynamics CRM Fetch and enter the Connection String in the following format: https://CRMOnlineURL;OrganizationUniqueName

You can find and copy the Organization Unique Name by selecting Settings, Customizations, Developer Resources

FetchConnectionString

Select the Credentials button, enter your CRM online credentials, select OK and Next

ReportCredentials

At this point your credentials are verified and the Query Designer screen will open.  One of the easiest ways to add a query to the report is to open CRM Online and build an Advanced Find query, as your base, and select the Download Fetch XML button from the Ribbon menu.

image

Select the Save file option, save the xml file to your hard drive, open the saved file in Notepad and copy and past the XML in the Query Designer screen.

image

Now that you have your base query, you can tweak it as need to pull the desired data from CRM.  Select the Next button when you are satisfied with your query, select the desired Report type and select Next.

image

Add the fields to your report and select Next

image   image

Select a Report Style and select Next

image

Give your report a Name and select Finish

You can now add any finishing touches to the report like parameters, design changes etc.  When finished with all your changes you can upload the new report to CRM and make it available to the Organization for use.

Additional Resources:

How To: Creating Custom Report with Microsoft Dynamics CRM 2011 BIDS Fetch Extension

Getting Started with CRM 2011 Online Fetch XML Reporting

Create Custom Reports Using Business Intelligence Development Studio

Cheers

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,661 other followers

%d bloggers like this: