Posted 4 August 2017, 3:13 pm ESTI have a sub report that is showing the correct data of the first record on the main report, but it is not updating the (record)source to get the next data.
the source of the subreport is changed based on the ID of the current Record.
I am using this code:
If Len(OrderID) > 0 Then
rpt.SubProducts.Object.DataControl1.Source = Replace(rpt.SubProducts.Object.DataControl1.Source,"-999999",rpt.Fields("CurrentOrderID").Value)
This code is on the OnFetchData Sub.
One way it works is loading and uploading the Subreport on the OnFetchData, but it takes a lot of time to process the report. I know it is not the ideal way to do it and I hope I am missing something :)
Thanks in advance for any help.