CRM 2011 - Explicit pre-filter on SSRS report RRS feed

  • Question

  • I have a custom report that runs on custom entity on CRM. I use hidden parameter in report and use that in sql query of data-set. When I run this report on one record, record id is not passed by CRM and I end up getting a result with list. Any help  is much appreciated!


    Monday, April 20, 2015 8:48 PM

All replies

  • Hi,

         Refer to following article which explains how to do this step by step:


    Hope this helps.
    Minal Dahiya
    blog : http://minaldahiya.blogspot.com.au/

    If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"


    Tuesday, April 21, 2015 5:47 AM
  • Hello,

    Minal gave you an example with FetchXML. As you can also create SQL Based SSRS Reports in CRM 2011, this example gives you the solution.

    Hope it helps

    Kind Regards

    • Edited by Jochen- Tuesday, April 21, 2015 2:46 PM
    Tuesday, April 21, 2015 2:46 PM
  • Thanks for you response. We are using Sql based reports and with explicit parameter, not auto pre-filter. I dont have any issue with the report. Same report published on production environment works fine, but on our QA doesn't. Its weird. Anybody else came across such issue?


    Tuesday, April 21, 2015 3:48 PM