VetView Local Reports Parameters

These parameters may not necessarily correspond to Java Beans. A full list of available Java data bean types is available under our Labs Admin page: JavaBean Data Types for Jasper Reports

For Local Reports, you can set the Parameters that will be prompted for under the Local Reports screen when the report is selected by defining them in report setup.

The Type is the type of parameter that the report will feed from VetView to Jasper. All dates must be of the type Java.util..date.
The Label is how it will appear loaded into VetView.
The Name is the link between the Jasper report and the VetView database. The name should match what was set in iReport or Jasper Studio when you defined the parameter.
The Default Value may be useful for certain reports that usually have one primary variable, but may need another on occasion,

These parameters will automatically be passed through to the report in the code of VetView. If the parameter is valid for the query used in the report, then the results on the report will display the data that matches the parameter.

Parameter Type	Jasper Field Type	Purpose	Example use in a Query in Jasper
Date Range	Java.util.date	Selects a start date and an end date	a.date_created between $P{startDate} and $P{endDate}
(Regular) Text	java.lang.String	Allows you to search for any string based text field, such as Diagnosis. Allows special characters for non-US English alphabets.
Query Text	java.lang.String	Passes in selected text to an internal query to search the database. Adds an "escape" character to allow for quotes in a query, without breaking the string	use "keyword" as a search query : Where LOWER (cm.description) like '%$P!{keyword}%' to search for the string name.
Rich Text	java.lang.String	Passed through formatted text for display. Not intended for use with a query to the database, but to allow rapid editing of certain parts of a report that are not easily queried (e.g. modifying a list of students.)	NOTE: This parameter type must have the settings of HTML and Stretch to Fit to work correctly on your Jasper Report.
Number	java.lang.Long or java.lang.BigDecimel	Passes in a specific number	select * from HOSPITAL_EPISODES where animals_seen = '1'
String List	java.util.List	Allows you to search for multiple string based text fields that are comma separated	select * from HOSPITAL_EPISODES_COMMENTS where COMMENT_MESSAGE IN ($P{keyword})
Date	Java.util.date	Allows you to search for a specific date	select SCHEDULE_ID, SCHEDULE_TIME, STATUS from HOSPITAL_SCHEDULE_TIMES
Fiscal Quarter	Java.util.date	Selects a Fiscal Quarter	select CREATED_DATE from HOSPITAL_CREDIT_MEMO
Fiscal Year	Java.util.date	Selets a Fiscal Year	select TRAN_DATE from HOSPITAL_DEPOSITS
Adjustment Types	java.lang.String	Selects one Adjustment Type	select ADJUSTMENT_TYPE from HOSPITAL_ADJ_TYPE_MASTER
Adjustment Types List	java.util.List	Selects multiple Adjustment Types	select ADJ_TYPE from HOSPITAL_ADJUSTMENT
Value List	java.util.List	Allows you to load a specific value list to search and select	select VALUE_LIST_ID from HOSPITAL_VALUE_LIST_MASTER
Employee	Java.util.String	Selects a single Employee	where e.emp_id = $P{empID}
Employee List	java.util.List	Selects multiple employees
Unit	java.lang.Long	Selects one unit	select HOSPITAL_UNIT_ID from HOSPITAL_REMINDERS
Unit List	java.util.List	Selects multiple units
Inventory Location	java.lang.Long	Selects one inventory location
Inventory Location List	java.util.List	Selects multiple inventory locations
Catalog item	java.lang.Long	Selects one catalog item
Catalog Item List	java.util.List	Selects multiple catalog items
Product	java.lang.Long	Selects one product
Product List	java.util.List	Selects multiple products
Product Line	java.lang.Long	Selects one product line	Where l.product_line = $P{product_line}
Product Line List	java.util.List	Selects multiple product lines
Product Seq	java.lang.Long	Selects a range of product sequences	And m.product_seq_id = $P{seq}
Client	java.lang.String	Selects one client
Client List	java.util.List	Selects multiple clients
Result	java.lang.Long	Selects one result
Result List	java.util.List	Selects multiple results

VetView Wiki

Most recent releases of VetView: Version 4.1.3 Hotfix (Released 2/16/2024)

Contents