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.
Master - Detail with Stored Procedures
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Master - Detail with Stored Procedures
Hello,
Please try to set the "ReconnectOnEachRow" property for the detail data source.
Thank you.
Please try to set the "ReconnectOnEachRow" property for the detail data source.
Thank you.
Re: Master - Detail with Stored Procedures
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.
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Master - Detail with Stored Procedures
Hello,
Please send us your request with a detailed description on support@stimulsoft.com.
Thank you.
Please send us your request with a detailed description on support@stimulsoft.com.
Thank you.