Filter Functions

Filter functions insert filter member names in label objects. The fixed reference format for the function is:

<<filter SQLDataSourceName1,n>>

Where

n is the filter number in the order that is displayed in the SQL WHERE clause:

SELECT MONTH, PRODUCT, CITY, SALES, COGS FROM DETAILS WHERE PRODUCT = '100-10' AND MONTH = 'Aug'

<<filter ReportSQLDataSrc1, 0>> returns 100–10

<<filter ReportSQLDataSrc1, 1>> returns Aug