{"id":14213,"date":"2006-11-21T11:14:00","date_gmt":"2006-11-21T11:14:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/crm\/2006\/11\/21\/sales-pipeline-report\/"},"modified":"2023-05-31T15:32:06","modified_gmt":"2023-05-31T22:32:06","slug":"sales-pipeline-report","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2006\/11\/21\/sales-pipeline-report\/","title":{"rendered":"Sales Pipeline Report"},"content":{"rendered":"

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 \u2013 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\u2019ve 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\u2019s how one may slice and dice this report to view the sales pipeline of an organization.<\/p>\n

There are multiple grouping areas on the report:<\/p>\n

Group By Sales Process \u2013 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 \u201cNone\u201d bucket.<\/p>\n

Group By \u2013 The options here are:<\/p>\n