none
One or mor parameters were not specified for the subreport

    Question

  • I have a main report that has a sub report.  It all seems to work fine, except that I get the error "One or mor parameters were not specified for the subreport" when the second page of the report is rendered.  So I verifed that all the parameters for both reports are setup correctly, looked at the data to see if it that was causing the issue, etc....  I found nothing.

    Then I came across this article. 

    http://www.analyticsby.me/2009/10/one-or-more-parameters-were-not_09.html

    So I changed all the parameters on the sub report Available Values to none.  Now it works without issues. 

    My problem is that the sub report needs to be run independently.  By setting the Available Values to none, the user is unable to select values for the parameters.  This is not acceptable.

    I suppose I could create a duplicate report to use as the sub report, with all the Available Values set to none for the parameters, but that means I need to maintain two reports instead of one.

    This has to be a bug.

    Anyone come across this situation?

     


    Bill Behning

    Friday, December 13, 2013 10:39 PM

All replies

  • Hi Bill,

    Sorry for the delay.

    Based on my test, the error message hints that either the report parameter has not been passed from the main report to the subreport or that the wrong format of report parameter or an unacceptable value for the report parameter has been passed from the main report to the subreport.
     
    When passing the parameter from the main report to subreport, we can grant the parameter to Available values in the subreport. While the values passed should be contained by Available values of the parameter in the subreport. In this case, the error won't occur. In other words, the parameter in the subreport can contain Available values.

    If I have any misunderstanding, please feel free to contact me.

    Regards,
    Heidi Duan

    Heidi Duan
    TechNet Community Support


    Sunday, December 29, 2013 1:16 PM
  • This is not the case.  The parameter being passed does exist in the Available Values for the parameter in the sub report.  Also, the first  page of the parent report does not show an error on the sub report, but the second page does.

    Bill Behning

    Thursday, January 02, 2014 2:50 PM