Master - Detail with Stored Procedures
Posted: Wed Mar 29, 2023 12:05 pm
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.
I'm sure there is a way to do this. Any suggestions would be greatly appreciated.