(Working Copy) VetView Local Reports Parameters
- Kyle Robert L Nelson
Owned by Kyle Robert L Nelson
May 10, 2022
5 min read
Loading data...
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 | Visual on Local Report Screen |
---|---|---|---|---|
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.2.5 Hotfix (Released 10/31/2024)
Contents