Question “How can I create DADE QueryDataViews via code?” Solution The following example shows how to create a DADE datamodule that contains two query dataviews, customer/orders linked in a master/detail relationship. Download: CreateDataModCustOrderLinkedDataViews.zip Delphi code sample: procedure TForm1.CreateDataViews; var lDataModule: TdaDataModule; begin // create data module lDataModule := daGetDataModule(ppReport1); if lDataModule = nil then lDataModule  Full Article…

Question “How can I add search criteria that will be not be visible to my end-users?” Solution The following example shows how to use the DataView.OnBeforeGenerateSQL and OnAfterGenerateSQL events to and remove search criteria that cannot be seen by the end-user. Download:  DADEInvisibleSearchCriteria.zip Delphi code sample: procedure TForm1.Button1Click(Sender: TObject); begin PrepareReport(ppReport1); ppReport1.Print; end; procedure TForm1.PrepareReport(aReport:  Full Article…

Question “Our end-user reporting solution needs to implement a security scheme to limit the data that is available to end-users.” Solution Use the DataDictionary to limit which tables and fields are available to end-users. To limit specific table records that are accessible requires that you modify the SQL statement submitted to the database. The best  Full Article…