Contents
Open the report in the report designer tool and then go to the MISC tab to change the sharing options.
The Share With dropdown allows you to share your report with IRIS uses in the following IRIS Custom Report groups:
The Rights dropdown allows you to give the users you are choosing to share the report with different levels of access. The levels of access you can grant are as follows:
Type | Filter | Description |
---|---|---|
Comparison | Is Less Than | Displays only items whose values are less than the input values. |
Comparison | Is Greater Than | Displays only items whose values are greater than the input values. |
Comparison | Between | Displays only items whose values lie between the input values. |
Comparison | Isn't Less Than | Displays only items whose values are not less than the input value. |
Comparison | Isn't Greater Than | Displays only items whose values are not greater than the input value. |
Comparison | Isn't Between | Displays only items whose values are between the input values. |
Equivalence | Equals | Manual text entry of the comparison value(s) separated with commas for easy copy/paste from CSV. |
Equivalence | Equals(List) | Manual text entry of the comparison value(s) separated by intelligently parsed delimiters. User delimiter use must be consistent. For example of consistent use: 1, 2, 3, 4 or 1-2-3-4 or 1 2 3 4 |
Equivalence | Equals(Autocomplete) | Manual text entry of the comparison value(s) that displays a list of options as you type. Separate each value with a comma. |
Equivalence | Equals(Select) | Allows you to select a single value from a dropdown list. |
Equivalence | Equals(Multiple) | Allows you to select multiple values from a scrollable list. Use ctrl+click to highlight multiple values (command+click on Mac). |
Equivalence | Equals(Popup) | Allows selection of multiple values from a popup list of checkboxes. |
Equivalence | Doesn't Equal | Exactly the opposite of equals. |
Equivalence | Doesn't Equal (Select) | The opposite of Equals (Select). |
Equivalence | Doesn't Equal (Multiple) | The opposite of Equals (Multiple). |
Equivalence | Doesn't Equal (Popup) | The opposite of Equals (Popup). |
Field Comparison | Is Less Than (Field) | Allows you to compare one field to another. Determines if the first field is less than the second field. |
Field Comparison | Is Greater Than (Field) | Allows you to see if one field is greater than another field. |
Field Comparison | Equals (Field) | Determines if one field value equals another. This is useful for joining tables on multiple fields. |
Field Comparison | Not Equals (Field) | The opposite of Equals(Field). |
Date/Time | Between (Calendar) | Allows you to select two dates from a calendar popup to filter on. This filter is inclusive - any dates equal to or between the specified values will be included. |
Date/Time | In Time Period | Allows you to select from a list of time periods to filter on. |
Date/Time | Less Than Days Old | Allows a single numeric entry to represent the days and uses that as a filter. |
Date/Time | Greater Than Days Old | The opposite of Less Than Days Old |
Date/Time | Equals Days Old | Filters on records that are only as many days old as you specify. |
String | Like | Determines if the value of the field contains the given text. |
String | Begins With | Determines if the value of the field begins with the given text. |
String | Ends With | Determines if the value of the field ends with the given text. |
String | Isn't Like | The opposite of Like. |
There is a type of report filter that only applies to dates that lets you choose a start and end date for a filter.
Figure. In report design mode, this is an example of a filter that uses a "Between" control to select start and end dates for a report.
Figure. This is how the filter looks when running the report.
The “Between(Calendar)” is inclusive. It looks at the date portion of a datetime field. So any date which is equal to or within the specified values will be included.
Figure 3 Checkbox on the Custom Report Filters tab making the filters appear in printed or saved reports.
Figure 4 Example of how the filters display in a printed or exported report.
There are two possible solutions:
If a field is of the SQL TEXT data type, you should not check the “Distinct” checkbox on the Data Sources tab.
It is because the file is not a native MS Excel file. It is a plain text file with information which Excel can read and convert, but Excel will display a warning before opening.
No, unfortunately, that is not possible
No, however, Izenda uses standard HTML color names. Here is a link to a good reference for all 140 colors - http://www.w3schools.com/html/html_colornames.asp
For instance, if we run a report using the IRISCASE and MGCASE tables, IRIS automatically filters out records that have no data in the MGCASE table (because have no MG program). However, we want to include those sites since we are looking at a number of different data points.
From the data sources tab, choose the tables and then check "allow nulls". By checking the 'Allow nulls' checkbox, you tell the system to use an OUTER JOIN as its join type.
From the MISC tab, a custom reports may be set-up to send a report by email on a recurring schedule.
Control | Description |
---|---|
Schedule | Set the schedule date and time. |
Repeat Type | Set the repeat frequency from a list of possibilities. |
Send Email As | The only option is Link. When the report is emailed, the email message will contain a link to open the report in IRIS. Using a link prevents sensitive information from being emailed in an unsecure manner. |
Recipients | Enter a comma separated list of recipients. |
There are two types of time period in the Repeat Type: Every TimePeriod and Alert TimePeriod.