PdcReport.AddFilter - Revision history

Mike: /* Notes */

2020-12-11T15:39:13Z

Notes

← Older revision		Revision as of 15:39, 11 December 2020
Line 13:		Line 13:

	The methode AddFilter doesn't work in combination with the Print and the Printpreview methode.		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 ==		== Code example ==

TC at 09:02, 30 November 2016

2016-11-30T09:02:41Z

← Older revision		Revision as of 09:02, 30 November 2016
Line 21:		Line 21:

	set objReport = pdc.Reports.Open(336)		set objReport = pdc.Reports.Open(336)
	if objReport.AddFilter("~~DO_ORDER~~", "DO_ORDNR='00464'") then		if objReport.AddFilter("DO_CALC", "DO_ORDNR='00464'") then
	objReport.PrintToPrinter 1, ""		objReport.PrintToPrinter 1, ""
	else		else

TC at 09:49, 13 March 2014

2014-03-13T09:49:11Z

← Older revision		Revision as of 09:49, 13 March 2014
Line 9:		Line 9:

	'''Parameters - Description'''<br />		'''Parameters - Description'''<br />
	TableName - The (case sensitive!!!!) name of the report table which has to be filtered.<br />		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 ("").<br />
	Filter - The filter value like a filter in PdC.<br />		Filter - The filter value like a filter in PdC.<br />

TC at 06:09, 5 November 2013

2013-11-05T06:09:47Z

← Older revision		Revision as of 06:09, 5 November 2013
Line 9:		Line 9:

	'''Parameters - Description'''<br />		'''Parameters - Description'''<br />
	TableName - The ~~reporttablename~~ which has to be filtered.<br />		TableName - The (case sensitive!!!!) name of the report table which has to be filtered.<br />
	Filter - The filter value like a filter in PdC.<br />		Filter - The filter value like a filter in PdC.<br />

Mike: /* Code example */

2013-07-26T11:49:08Z

Code example

← Older revision		Revision as of 11:49, 26 July 2013
Line 21:		Line 21:

	set objReport = pdc.Reports.Open(336)		set objReport = pdc.Reports.Open(336)
	if objReport.AddFilter("~~DO_CALC~~", "DO_ORDNR='00464'") then		if objReport.AddFilter("DO_ORDER", "DO_ORDNR='00464'") then
	objReport.PrintToPrinter 1, ""		objReport.PrintToPrinter 1, ""
	else		else

Mike: Created page with "== Declaration == AddFilter(TableName as String,Filter as String) as Boolean == Description == == Notes == With this method a filter can be added to the report, to filter d..."

2012-05-21T11:50:35Z

Created page with "== Declaration == AddFilter(TableName as String,Filter as String) as Boolean == Description == == Notes == With this method a filter can be added to the report, to filter d..."

New page

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

== Description ==

== Notes ==
With this method a filter can be added to the report, to filter data.<br />

'''Parameters - Description'''<br />
TableName - The reporttablename which has to be filtered.<br />
Filter - The filter value like a filter in PdC.<br />

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

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

<source lang="vb">
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
</source>

== Availability ==
Available since February 2011 (from version 4.2).