Drilling down on folders

available.csp allows the user to drill down on folders, beginning with those folders at the top level. To drill down on folders, available.csp passes to itself the query string parameter currID. The currID parameter represents the SI_ID property of the folder that is being drilled down on.

Note that folder that is being drilled down on is the child of the current folder. In order to retrieve the SI_ID property of this child, a query is made that uses SI_PARENTID as a condition:

"SELECT " & <properties> & "FROM CI_INFOOBJECTS WHERE SI_PARENTID = " & currentID

For more information on drilling down on folders, see Lesson 2a: Navigating through folders in the Crystal Enterprise Tutorial.

Searching for reports

Searching in available.csp is accomplished by passing to itself two parameters: searchString and searchParameter. The searchString parameter represents the string to search for, and the searchParameter parameter represents the properties (for example, SI_NAME and SI_DESCRIPTION) to search for.

For detailed information on case-insensitive report searches, see Lesson 2d: Searching for reports in the Crystal Enterprise Tutorial.