Displaying FetchXML predefined filter values on my report RRS feed

  • Question

  • HI, My CRM Online customer wants to see the values of the filters selected (i.e. the pre filters, or when they click edit filters and change the values etc.).How!?!?!  Sure it's simple, but I'm stumped - thanks...


    Thank you for you time folks!

    Saturday, November 7, 2015 11:26 AM

All replies

  • You can get the filters if you add a CRM_FilterText parameter to the report - see https://technet.microsoft.com/en-us/library/dn531165.aspx

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Saturday, November 7, 2015 12:54 PM
  • Thanks for the reply David.

    I already have the parameters in place and they are being selected via the advanced find view.  The customer wants to have the selected values displayed on the report.  IN a non FetchXML based report, I would have just


    However if I do this for these FetchXML report I get the FetchXML query displayed...  How do I just get the values the user has selected in the Advanced Find (i.e. when they click Edit Filters) ???

    thank you

    Thank you for you time folks!

    Saturday, November 7, 2015 7:09 PM
  • Hi,

    If you have enabled your report for prefiltering you can just show the prefilterparameter text ex: CRM_FilteredContact Text.

    You can show the default condition specified in report UI. You can not show fetchxml query i believe.



    • Edited by Kalim Khan Monday, November 9, 2015 2:24 PM
    Monday, November 9, 2015 2:20 PM
  • Guys, clearly I'm not understanding how to do things!  If I add the report parameter to the report (either the .value or .label) - the whole fetchxml string gets output...  Just to confirm, this is using the prefilter with CRM Online....


    Thank you for you time folks!

    Monday, November 9, 2015 3:10 PM