Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
WebHierarchicalDataSource with Parent and Child SQL stored procedures

I have a WebHierarchicalDataSource set up and the parent and child datasources use stored procedures. Within the Smart Tag screens I am able to tie the two together with the "Claim_ID" field and my stored procedure for the child datasource includes a "Claim_ID" parameter, but I can't figure out how to setup the select parameter in the child datasource. As of now it looks like this: . How do I make it send the "Claim_ID" that is selected in the parent datasource?

No Data
  • 2525
    Verified Answer


    You can look into this sample for an example on how to bind to a grid using a WebHierarchicalDataSource:

    In the DataRelation field, the ID and view of the child are stated which establishes the relation between the parent and child bands.

    Let me know if you have any further questions.