We used to have a long list of reports in MSCRM version 1.2. For MSCRM version 3.0 (v3), when we moved to SQL Reporting Services (SRS), many of these reports were consolidated and the number of reports that v3 shipped with was dramatically reduced. One of the reports became a consolidated version of many old reports – the Sales Pipeline Report. Though we lost the pretty pipeline to show the sales pipeline report when we moved away from Crystal Reports, we also incorporated interesting functionality using the power of SRS into this report. I’ve seen a few messages on the newsgroups asking about what happened to the old sales report where people could see the sales by each user etc. So here’s how one may slice and dice this report to view the sales pipeline of an organization.
There are multiple grouping areas on the report:
Group By Sales Process – this will show the Sales Processes that are active and have at least one opportunity with that sales process running on it. The opportunities that do not have a sales process running on them will be displayed under the “None” bucket.
Group By – The options here are
Revenue – The options here are
Here are two sample screenshots
Grouped by Rating and using Estimated revenue:
Same set of opportunities Grouped by Weighted Revenue
Overall, the sales pipeline report is a complex report that could help slice and dice your data in different ways. There may be some reasons why this report works or doesn’t work for you and I’d love to hear them.
I’m glad you brought this report up because I’ve had nothing but complaints about it since upgrading to 3.0. Here’s the problems our staff have experienced:
First, when they group by Sales User and five or six users appear on the chart, no totals appear for the bars on the left and right ends, just in the middle. Since the detail reports don’t contain a total either, they have to manually add up all the individual amounts to get the two missing totals.
I also had complaints that there’s no obvious way to tell that you can drill down into information on the totals as well as the detail reports. Worse, if the report is filtered by a specific month and a salesperson had a hard time that month, his or her graph may only be a few pixels high. That means our users have to zoom way in on the report in order to click the bar. Everyone expected to be able to click on a salesperson’s name to get the detail, but they can’t.
Our users have also said that the detail report isn’t useful because it doesn’t show the name of the company the opportunity is for. All they have to go on is the Topic field shown in the opportunity column. As the salespeople don't understand the purpose of Topic as they’re already filling out the Customer and Opportunity Type fields, what’s entered in it tends to be useless on a report.
Finally, they're frustrated that they have to first print the totals, then click on each salesperson and print each of those reports. It could take more than a dozen clicks and nearly as many pieces of paper to get what could fit on a single sheet. They expected to both see and be able to print the totals and details at the same time.
They’re all coming to me for answers, so any help you can provide would make my life a lot easier.
The report's great, but there is one thing that is bothering me about it: is it possible to somehow make the report sorted by the sales stage and not by alphabetical order?
IS there a way to place the quotas on teh port and show for each sales person not only sales but compare it to the quota?
My apologies for not coming back to check the comments. To Ryan and Orca - I have collected the feedback and I will put it for the future revisions.
Eli - it is possible to edit all built-in reports in the SQL Reporting Services editor in Visual Studio and add any MSCRM fields that are accessible through filtered views. We don't have a quota+pipeline report. that is a good feedback I can take back to the feature team. Thank you for your comments and feedback!
We encountered the same problems regarding some value totals not appearing on the coloured bands, and not sorted by Sales Stage. So we edited the Sales Pipeline Report in Visual Studio to correct the 2 issues.
I am writing an article on how to do this in the hope that partners can resolve this for their customers.