Microsoft CRM 4.0 SSRS Report Run on Current Record from Quote Entry Window

Posted on 2012-09-05
Last Modified: 2012-09-06
I have a custom report created in SSRS and imported into CRM Reports.  I set the Related Records Type to be Quotes so that it shows up in the Reports drop down list in the Quote Entry window.  It shows up as Run on All Records.  A quote report I created in CRM with a Related Records Type of Quote shows up as Run on Current Record.  Is there a way I can pass the current Quote Number on the open window to my custom SSRS report so that it will run on the current record?
Question by:sbdt8631
    LVL 29

    Accepted Solution

    Have a look at this article which I believe answers your query:

    Also, review the topic on pre-filtering

    Hope these help.
    LVL 1

    Author Comment

    I did as you suggested but my report still shows up under the run on all records part of the drop down menu in the Quote screen instead of the run on current record.  Another report I made using the CRM report wizard shows up on the run on current record.  Attached is my report query and setup screen.
    LVL 1

    Author Closing Comment

    "The behavior that I've observed is that if the report is created initially such that it does not adhere to context-sensitivity, it will rightly appear under the "Run on All Records" section. Later on, if you modify the report definition to include context-sensitivity it will still remain in this section.
    If that is the case simply deleting and recreating the report will resolve this issue. At least that's been my experience. "

    I deleted it and recreated it and it worked fine.
    LVL 29

    Expert Comment

    Glad that you resolved this and thanks for posting the link to show that someone else had the same issue.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now