SF (Selection Formula) parameter

Specifies a selection formula.

SF=<formula>

<formula> is a selection formula in string format.

Example

http://myServer/myVirtualDirectory/viewrpt.cwr?id=152&apstoken=A1B2&sf={my.Studio}%3d'myFilmCompany'

This is appended to any selection formulas already contained in Boxoffic.rpt; that is, the generated report will be based on existing selection formulas and the newly specified SF parameter. For example, if the report already contains a selection formula that selects the records for film studios in the state of California, and then the SF parameter is used to append a formula that selects the records for "myFilmCompany," information on that particular studio will be displayed. If the SF parameter had specified a value such as "otherFilmCompany," and this studio was located only in the state of Florida, then the requested report would contain no data.

Note:    The new selection formula is not saved with the original report file. It is only valid for the currently requested job.