I am having issues passing a parameter from my master report based on a stored procedure to my detail report based upon another stored procedure. I have narrowed down the problem to the following situation:
If the master report is based upon a stored procedure and I try to pass a parameter as a field from that procedure, I get a "object reference not set to an instance of an object" error in preview.
I have tested this with a variety of scenarios and this seems to be the only one causing the issue. I am setting the parameter for the subreport in the Designer as seen in the SetParameter.png attached.
It works if the master report is set to an SQL statement (not easily accommodated) or if I hard code the parameter to a value. It is only the above scenario that I cannot get to work.