Users can now filter a dataset before a report is generated in QRDesign 1.59

The feature of QRDesign 1.4 and earlier versions which allows a user to filter a dataset before the report is generated was not implemented fully in QR Design 1.59 at the time we acquired it. There is a straightforward workaround using the ‘BeforeDatasetOpen’ event which is called when the table or query is opened. The event code is listed below:

procedure TForm1.Designer1BeforeOpenDataset(DataSet: TDataSet);
if designer1.ShowFilterBeforePrint then
filtdlg.Edit1.Text := dataset.Filter;
if not filtdlg.cancel then
dataset.Filter := filtdlg.Edit1.Text;

FiltDlg is a standard Windows dialog with an ‘OK’ button, a ‘Cancel’ button and an edit control (‘Edit1’) to allow the user to enter a new filter string.

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt