locked
How to correctly add a parameter to the CRM Reports url? RRS feed

  • Question

  • I have a SSRS report that I have added to Reports in CRM 2011 organization. This SSRS report requires a hidden parameter to be entered in order for it to be generated.

    When I view the report using the Report Server url (DOMAIN/reportServer/...), it loads, but requires the hidden parameter, which is to be expected. Adding the hidden parameter (&ParameterName=ValueOfParameter) to the end of the url will allow the report to generate. 

    When I view the report using the CRM Reports url (http://DOMAIN/ORG_NAME/crmreports/viewer/viewer.aspx?action=run&helpID=RDL_NAME.rdl&id=%7b14299665-830E-E411-95AF-001DD8B71CB5%7d), I get a "Microsoft CRM Error Report" with the following "Error Description", which is to be expected: "A parameter expected by the report has not been supplied". I append the hidden parameter (&ParameterName=ValueOfParameter) to the url and I get another error with the following information.

    Error Details: Error executing child request for /ORG_NAME/CRMReports/viewer/QuirksViewer.aspx.

    The stack says it is an invalid parameter.

    How do I correctly add a parameter to the CRM Reports url? 

    Tuesday, July 29, 2014 10:31 PM

Answers

  • I ended up figuring it out myself. Here is the solution for anyone else that ends up needing it:

    http://DOMAIN/ORG_NAME/crmreports/viewer/viewer.aspx?action=run&helpID=RDL_NAME.rdl&id=%7b14299665-830E-E411-95AF-001DD8B71CB5%7d&p:ParameterName=ParameterValue

    Wednesday, July 30, 2014 1:27 PM