craigsboyd
IS-IT--Management
Recently I had occasion to create some reports with multiple detail bands. I put 3 remote views in the Dataenvironment, set indexes and relationships between them through code in the init of the DE. On Detail band 2 and 3 I placed the respective names of the target aliases ("View2", "View3") which are related to the driving alias ("View1") of the Report. I left Detail band 1 target alias blank, since that detail band contains content from View1. All was well and good for the first page of the report, but when I go to any other page in the report, other than the first, I get an error saying "View2 is not related to the current work area". It's as if the relationships from View1 into View2 and View3 are gone... as if the DE reloaded and didn't run the init code (I can get the same error right away if I remove my code from the DE init and run the report).
Now, I do the same thing through code... open the database and the subsequent remote views, index the child views and set relationships into them from View1. The report runs and everything is fine. I can page through the report and the relationships are static until I close the views.
Anyone know why this happens in VFP9?
Now, I do the same thing through code... open the database and the subsequent remote views, index the child views and set relationships into them from View1. The report runs and everything is fine. I can page through the report and the relationships are static until I close the views.
Anyone know why this happens in VFP9?
