Not all records in main report have records in subreport

  • 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?

  • Have you tried making the parameter nullable?

  • I've never done that.

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

  • Thanx.

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

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