Primer s tabelo in vnosnim poljem

Example with Table and Dialog Page

We will take a look at the example of the country register, which will be given the conditions in the window that will open before the report is displayed.

Open report '03B - Countries' that is in the program menu 'Settings | Subjects | Countries' and make a clone on which we will work.

Place an object for connection to the table on tab Data to the table and set property "Filtered" to 'True', "OrderFields" to 'acCountry' and "TableName" to 'dbo.vHE_SetCountry'.

On "Page1" click on title of band "Detail" and select dataset 'DlDBTable1'. Then replace for all fields dataset name from 'qReportIzpis' to 'DlDBTable1'.​


 
In  "File > NewDialog..." menu select a new dialog page. Drag and drop from toolbar label object with text "Country", edit box and button. In object inspector set button's property "ModalResult" to 'mrOk' and assign it the "OnClick" event. Write the next script for the event:

procedure Button1OnClick(Sender: TfrxComponent);
begin
    DlDBTable1.Filter := 'acCountry = ''' + UpperCase(Edit1.Text)+'%';
end;
 

Run the report and enter first letter of country as filter

Only countries that meet a filter (i.e. countries that name is starting with 'A') will be displayed.