Expression Language Techniques - A List

Modified on Wed, Jun 11 at 11:51 AM

Expression Language Techniques

Name	Description & Example
Find the First Record for a Student Restrictions: - Must be done after the Sort - Every column using this column must be done after the Sort. - The Sort MUST cluster all of each student's records together in a single block.	${ row.studentID != prevRow.studentID} Use the spelling of "student ID" used by the field in your selected table.
Find the Last Record for a Student Restrictions: - Must be done after the Sort - Every column using this column must be done after the Sort. - The Sort MUST cluster all of each student's records together in a single block.	${ row.studentID != nextRow.studentID} Use the spelling of "student ID" used by the field in your selected table.
Find the First Row in the Report - Must be done after the Sort - Every column using this column must be done after the Sort.	You can do this with any column that can't be "empty". Do this with an object id or other id column you know will never normally be empty: ${ empty prevRow.studentID } This will be true when the current row is the first row in the report (provided that the studentID field can never normally be blank) and false otherwise.
Find the last Row in the Report - Must be done after the Sort - Every column using this column must be done after the Sort.	You can do this with any column that can't be "empty". Do this with an object id or other id column you know will never normally be empty: ${ empty nextRow.studentID } This will be true when the current row is the last row in the report (provided that the studentID field can never normally be blank) and false otherwise.
Using a Parameter to control output	Create a parameter that contains - as a list - the options for how you want the report to behave. It's best if each option starts with a different letter - this makes processing the options easier. On the Parameters page, create a parametet with a type of "Custom List" ("Selecting from a drop down list that I create": The list is a set of options separated by a semi-colon: ; These Strings can be anything you want: Final Total Only;Each Student's Total;All Students, All Rows;Totals for AP Students only;Include AP Course info with AP Students Use the "rw:startsWith" function to understand which option has been chosen for the paraeterm. You can then change the report's behavior based on which option hassnn ${ rw:startsWith(params.SHOW,'All') ? ... Helpful functions for determining which parameter has been chosen include: - startsWith - endsWith - contains - in