Master-Detail report - both use stored procedures

4 posts, 1 answers
  1. Rod
    Rod avatar
    12 posts
    Member since:
    May 2010

    Posted 30 Jun 2015 Link to this post

    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>

  2. Answer
    Stef
    Admin
    Stef avatar
    3610 posts

    Posted 30 Jun 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Rod
    Rod avatar
    12 posts
    Member since:
    May 2010

    Posted 30 Jun 2015 in reply to Stef Link to this post

    Thank you for making me dig a little more. I have figured out NULLs in the passed parameter field were causing the issue.
  4. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 01 Jul 2015 Link to this post

    Hello Rod,

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

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top