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

Posted on 2008-11-17
Last Modified: 2012-06-27
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?
Question by:Pilkingtons-Tiles
    1 Comment
    LVL 5

    Accepted 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now