Master - Detail with Stored Procedures

Stimulsoft Ultimate discussion
Post Reply
compuaid
Posts: 14
Joined: Mon Aug 22, 2022 3:30 pm

Master - Detail with Stored Procedures

Post 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.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Master - Detail with Stored Procedures

Post by Lech Kulikowski »

Hello,

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

Thank you.
compuaid
Posts: 14
Joined: Mon Aug 22, 2022 3:30 pm

Re: Master - Detail with Stored Procedures

Post 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.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Master - Detail with Stored Procedures

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply