DBX master detail
dbxquery1 is an select * from data left join etc...
dbxquery2 is an select * from subdata left join etc... where id = :id
I set up the id param as data.id and the mastersource to dbxquery1
If I preview I get the error, cannot do this on a closed dataset, or if I change the create order a GPF. Fields are updated (ie no sql error). The way I solved it for now: in the beforeprintband of dbxquery1 I close dbxquery2 and open it again. This results in a correct report with again the notice that there are no sql errors otherwise this would not work.
Am i doing something wrong?
dbxquery2 is an select * from subdata left join etc... where id = :id
I set up the id param as data.id and the mastersource to dbxquery1
If I preview I get the error, cannot do this on a closed dataset, or if I change the create order a GPF. Fields are updated (ie no sql error). The way I solved it for now: in the beforeprintband of dbxquery1 I close dbxquery2 and open it again. This results in a correct report with again the notice that there are no sql errors otherwise this would not work.
Am i doing something wrong?
Comments
my solution was to create a manual masterdetail en take care myself of the regfresh on 'master' skip