Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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!

    vijay

    Monday, April 20, 2015 8:48 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

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

    http://www.njevity.com/blog/creating-dynamics-crm-2011-reports-sql-reporting-services-pre-filtering-and-default-filters

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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?

    vijay

    Tuesday, April 21, 2015 3:48 PM