locked
Passing parameter to SSRS query from crm report pane RRS feed

  • Question

  • How to pass parameter to SSRS dasaset query from crm report panel (NOT BY'+@CRM_FilteredAppointment+' ,  becouse this parameter need to be used to filter other joined entity in the query)

    Example:

    and then in the dataset query in SSRS, I want  to use passed selected date: (2012-09-12) in the query. Like below.

    Very important is to have only this date, not whole string which could be in CRM_FilteredAppointment

    The question is how to do it ? IS IT POSSIBLE ? Any suggestions?


    Marcin from Live




    • Edited by urwis Monday, September 3, 2012 9:59 AM
    Monday, September 3, 2012 8:16 AM

All replies

  • You should be able to add a normal Parameter (e.g. @EndDate) within the report designer, and the user would then get the normal Reporting Services prompt to input the parameter value

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

    Monday, September 3, 2012 8:50 AM
    Moderator
  • Yes, but then end user will have to put this same date two times, ones in the CRM2011 panel to filter appointments, and then in  the normal Reporting Services prompt to Filter/count Accounts.

    Marcin from Live

    Monday, September 3, 2012 10:04 AM