Master-Detail report - both use stored procedures

[Rod]

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.

Suggestions?

ROD>

[Stef]

Hello Rod,

Please double-check how data is filtered in reports, it is possible that the SQL parameters are not mapped correctly to report parameters - Using Parameters with the SqlDataSource component. Also compare your settings to these in the How to: Create a Master-Detail Report Using a SubReport Item tutorial.

If you need further help, please open a support ticket and send us a demo project illustrating your settings.

Regards,
Stef
Telerik

[Rod]

Thank you for making me dig a little more. I have figured out NULLs in the passed parameter field were causing the issue.

[Stef]

Hello Rod,

Thank you for this update.
I am glad to hear the issue is resolved.

Regards,
Stef
Telerik