Question “How can I link DADE pipelines manually? Sometimes I need to manually edit the SQL or need to bypass generation of the magic sql Solution For the linked data traversal to work properly, make sure the detail query selects all records required for the entire report and Order By the linking field(s). The following  Full Article…

Question “How do I link a pipeline (dataview) I’ve created in DADE with a standard pipeline I’ve placed on my form/datamodule or vice versa?” Solution Gain access to the pipeline object of the TppDataView via the daGetDataModule routine.  Then manually link the pipelines as you would normally in code using a TppMasterFieldLink object. Download: LinkDADEPipeToStandardPipe.zip  Full Article…

Linking DataViews in the ReportBuilder Data workspace (DADE), requires that the detail data be sorted by the linking fields. When DataViews are linked, DADE generates special linking SQL for the detail DataView. The linking SQL (Magic SQL) can be viewed by positioning the mouse over the DataView window and pressing Ctrl + Left Mouse button.  Full Article…