Not all records in main report have records in subreport

  • NineIron

    SSChampion

    Points: 12523

    When a record in the main report doesn't have a corresponding record in the subreport I get an error. "One or more parameters were not specified for the subreport...". How can I avoid the error?

  • heb1014

    Hall of Fame

    Points: 3790

    Have you tried making the parameter nullable?

  • NineIron

    SSChampion

    Points: 12523

    I've never done that.

  • heb1014

    Hall of Fame

    Points: 3790

    You should look into that.  It's just an option on the parameter.  Really easy to set and it may solve your problem.  If you are calling a stored procedure and passing the parameter to it, you'll need to make that nullable too.  The syntax on that is @Parameter datatype = NULL.

  • NineIron

    SSChampion

    Points: 12523

    Thanx.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply