PdcReport.AddFilter

Declaration

AddFilter(TableName as String,Filter as String) as Boolean

Notes

With this method a filter can be added to the report, to filter data.

Parameters - Description
TableName - The (case sensitive!!!!) name of the report table which has to be filtered. In case of a manual SQL with a manual name, leave the table name empty ("").
Filter - The filter value like a filter in PdC.

The methode AddFilter doesn't work in combination with the Print and the Printpreview methode.

For PdC version 5.7.5.0 and up, the ReportEditor table alias is used for locating the table which has to be filtered (also case sensitive). In previous versions of PdC the filter will be added to the first table found, based on the given TableName.

Code example

This example code opens a report with ID 336 and shows the report only for calculation "00464".

dim objReport

  set objReport = pdc.Reports.Open(336)
  if objReport.AddFilter("DO_CALC", "DO_ORDNR='00464'") then
    objReport.PrintToPrinter 1, ""
  else
    msgbox "This is not a correct filter."
  end if

Availability

Available since February 2011 (from version 4.2).