Page 1 of 1

Master - Detail with Stored Procedures

Posted: Wed Mar 29, 2023 12:05 pm
by compuaid
I'm trying to create a Master - Detail report with two data sources. Both are stored procedures. In the Master source I have a field "Master.BudgetPK". I want to use this as a parameter for the detail band to call the stored procedure to retrieve the child records. I have tried setting the parameter expression in the data source for the detail band to equal Master.BudgetPK but it doesn't seem to call the stored procedure with this value when the master record changes.

I'm sure there is a way to do this. Any suggestions would be greatly appreciated.

Re: Master - Detail with Stored Procedures

Posted: Thu Mar 30, 2023 7:47 am
by Lech Kulikowski
Hello,

Please try to set the "ReconnectOnEachRow" property for the detail data source.

Thank you.

Re: Master - Detail with Stored Procedures

Posted: Tue May 16, 2023 9:08 pm
by compuaid
Has there been any progress on getting the "ReconnectOnEachRow" feature working in Stimulsoft JS when using Stored Procedures for both the Master and Child bands? We are still unable to produce Master - Detail reports with stored procedures when running Stimulsoft.js in the JavaScript viewer. This is a critical need for us.

Re: Master - Detail with Stored Procedures

Posted: Wed May 17, 2023 9:36 am
by Lech Kulikowski
Hello,

Please send us your request with a detailed description on support@stimulsoft.com.

Thank you.