Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Displaying FetchXML predefined filter values on my report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

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

    Tim

    Thank you for you time folks!

    Saturday, November 7, 2015 11:26 AM

All replies

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

    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 

    Join(parameters!parammane,value",")

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

    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.

    Thanks!

    Kalim


    • Edited by Kalim Khan Monday, November 9, 2015 2:24 PM
    Monday, November 9, 2015 2:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

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

    Thanks.

    Thank you for you time folks!

    Monday, November 9, 2015 3:10 PM