• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1462
  • Last Modified:

Custom Reports in Microsoft Dynamics CRM 4.0. Using Stored Procedures.

I have to write a Management report that calculates the conversion ratios from lead -> opportunity -> won.

My Choice is to either create a Report with several datasets and do the calculation on the report document Or write a nice stored procedure which uses the filtered views to return a single dataset.

How unsupported is the second choice? Do I have alternatives?
1 Solution
Using the filtered views and stored procedures is supported, the only part that would not really be supported would be making modifications to the CRM database (i.e. adding the stored procedure to the CRM database), so as a result it is usually recommended to create a seperate database for storing these kind of reporting Stored Proce and views etc. just to make sure that they aren't accidentally overwritten during a restore or migration or something of the likes. So I would create the stored proecedure to perform all your calculations and return the dataset you are after, but just store it in a seperate database and point your report to that accordingly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now