How to Create a Microsoft Dynamics CRM 4 Report Subscription in less than 15 minutes
I frequently respond to questions about creating Report Subscriptions in Dynamics CRM 4 so I thought it would be helpful to provide some detailed information.
Scheduling report subscriptions is fairly easy if you know the right steps to take. Following the steps below should get you up and running with report subscriptions fairly quickly and you can begin Wowing your users with the delivery of reports directly to their Outlook Inbox. Please note, that this does not work for ‘Drill Through" Reports. Additional changes are required to make the ‘Drill Through’ behavior work as expected.
The first step you need to take is to open your CRM application and navigate to Workplace, Reports. Identify and Select the report that you want to schedule, select More Actions from the top menu bar and select Schedule Report from the dropdown.
A wizard dialogue window will open. Select On Demand and Next. We don’t need to select On Schedule because we don’t necessarily want to run Report Snapshots; we want to setup a Subscription for delivery. If you decide you want to create Snapshots in addition to a Subscription, you can do that later from the Report Server
If you want to change the Default Parameters used for the Subscription, select Edit Filter, select the filtering criteria, and Save or leave the defaults provided and Select Next
Select “No just save the Snapshot Definition and select Save
Now if you look at your Report grid in CRM you will see a new report listed with the same name referenced on the Save wizard dialogue window. In this case the report name was: Account Distribution – On-demand Snapshots 7_17_2009 9_15 AM
If you select the report and select the Edit Report button, a new window will open showing you the details of the report. Select Administration and you will see that the report is set to Individual View only as users in the Organization do not need to view this report directly from the Dynamics Application. Leave the Settings and close the window.
Now we will move on to the CRM Report Server
You can access your Reporting Services Home page by using the URL http://NameofReportServer/reports. The Reporting Services Home page URL is different than the Report Server which is located at http://NameofReportServer/reportserver so ensure you are using the correct URL.
You will see a list of all your Report folders after the page opens. In this example you do not see the full name of the Report folder but you will see the full name in your deployment. In the upper right-hand corner of the Reporting Services Home page, select Show Details
You will notice that the page layout changes slightly and you can now see a new link name Edit
Select the Report folder that contains the reports for your CRM 4.0 deployment and select the 4.0 folder
After you select the 4.0 folder, you will see a list of your CRM reports. Locate the report that you created in the CRM application. You can easily find it as the report name, which in this example was “Account Distribution – On-demand Snapshots 7_17_2009 9_15 AM”, is included in the Description field.
Select the Edit Icon link located to the left of the report
Select the Subscriptions tab
Select the New Subscription button
This will open the window that allows you to enter the details for the report subscription
You can now enter the information that will determine how the report is delivered, who receives it and the report delivery frequency.
· Leave the default delivery method of E-mail selected
· Enter the e-mail address for the recipients
o I generally include my e-mail address in the BCC field to ensure the report runs as expected at least the first few times and the format is what I intended
· Enter the Reply-To e-mail address
· Modify the Subject line for whatever you prefer
o This will be the subject line of the e-mail
o At a minimum Replace “ @ReportName” with the actual Report Name otherwise the value will be the GUID of the report which is not a user friendly name
· Leave the Include Report and select the Render Format option you prefer. I generally use Excel as this gives users the option to manipulate the report data in a format familiar to them.
· Leave the Include Link only if it is ok with you that users open the Report directly from the Report Server rather than through the CRM application
· Set Priority
· Add Comments
· Select the Schedule you want the Report to run by selecting the Select Schedule button
· Select the OK button and the Subscription is created and saved
Saving the Subscription will create a SQL job that runs on the date and time you indicated to deliver the report to your recipients. If you have not yet setup your Report Server for E-Mail Delivery then review this MSDN article for the steps needed to implement that service.
Once you create a few subscriptions, you will be able to take a few shortcuts that will reduce the steps needed to create new subscriptions. After generating one or two of these subscriptions, you will be an expert.
Happy Subscription Reporting!
This was so good we posted it to the CRM Team Blog. Thanks Donna. :o)
good blog, helpful. stuck with internal error when saving the subscription. logs are useless to me.
there are several possible things that can go wrong when creating report subscriptions so it will be challenging to assist. Having said that, you can send me a direct message on Twitter. My profile name is edwardsdna. I will see what I can do to help.
business blocks twitter access.
was able to get a report via email. sadly for some reason the report folder is no longer appearing in reporting services nor does it appear in the web site http://servername/reports
no clue what happened.
I just replied to your e-mail address
Donna, This is what I have been looking for, but I can’t even get past the first instructions. I have no “more actions” option like your first screen shot displays and no schedule report from the drop down. I’m certain I have one of the most recent versions of CRM (4?) because I started using the program in June. Can you help?
You’ll need to ensure you have a security role that gives you the rights necessary to perform the work. Do you have the System Administator role in CRM?
Yes, I do have the admin role.
In my version there is a ribbon, and not a title bar. I have an “actions” section on the ribbon, but it does not have a schedule report anywhere that I can see.
Could you email me and I could show you a screenshot of what I am working with. I must be missing something. You can reach me at firstname.lastname@example.org. Any help is appreciated
I am using CRM online. I found one of your older posts saying that CRM online is not able to schedule reports at this time, that message was over 3 years old, has this since changed or is that the reason my schedule reports button does not seem to exist?
At this time, you can not schedule reports for delivery in CRM. That might change in the future but is not available now. You would need to pull the data down to a local SQL instance and then schedule reports from there. You can use Scribe to replicate the data to a local SQL instance. I hope this helps.
How do I found the name of my report server? I’m stuck here!
Thanks for your help and for posting this article.
Go to the server where SQL Reporting Services is installed and open the Report Server Configuration Manager. It will show you the URL on one of the left navigation menu links.
Sorry. I’m sure this is a tedious question to answer: I have no clue how to find or access SQL reporting services. I can find and create reports within CRM workplace with no problem, but I’ve never seen SQL reporting services. Do I have to install that separately?
No worries about the question. Are you using CRM Online or CRM OnPremise. If OnPremise then you can open the Deployment Manager, select Servers and you will find the servers listed. Reporting Services is often installed on the SQL Server.
If this is CRM Online, you will have to access the Reporting Service through the Report Authoring Extensions via Visual Studio (BIDS).
Keep in mind that this post was written for CRM 4 so will not be applicable to CRM Online 2011. If you need help setting up a reporting environment for CRM Online, then I need to write a new post. Let me know.
Hi Donna, I am indeed using CRM Online 2011 – any help for this platform would be very much appreciated.
Hey there! This is my first comment here so I just wanted to give
a quick shout out and tell you I truly enjoy reading through your posts.
Can you suggest any other blogs/websites/forums that go over the same topics?
Thanks a lot!
Have a read through this post.
If some one needs expert view on the topic of blogging and site-building after that
i advise him/her to go to see this webpage, Keep up the good job.
In depth information, finally! Quick question though, how do you coordinate your site
content? Do you have software or do you do it manually?
I only ask cause your blog seems pro and I would like to follow your example;
hope you don’t mind!
Hi, thanks for the compliment, I appreciate it. I use Live Writer from Microsoft to write my articles and publish to the site. I used one of WordPress’s templates for the site. Nothing special beyond that. Have a good day.
I’m not that much of a internet reader to be honest but your blogs really nice, keep it up!
I’ll go ahead and bookmark your site to come back in the future. Cheers