Advanced Properties
This section briefly outlines the different field settings available and what they can be used for.
Properties Table
| Property | Description |
|---|---|
Column Group | Define which parent column this column belongs to |
Break Page After VG (PDF) | Not used |
Hide this field | Hides the field from the report completely |
Sort (z-a) | Sorts the values of this column from Z-A |
Italic | Formats the values in this column to Italics |
Bold | Formats the values in this column to Bold |
Width | Sets the width of a column to px or pt |
Label Justification | Aligns the column header to the left, middle or right |
Value Justification | Aligns the column values to the left, middle or right |
URL | This field can be used to turn the value into a hyperlink |
Subtotal Function | Changes the subtotal value to be a Count, Sum, Average etc |
Gradient Cells Shading | Applies a gradient shade to the column which gets darker for higher values |
Text Highlight | Changes the text colour for certain values or value ranges |
Cell Highlight | Changes the cell colour for certain values or value ranges |
Value Ranges | Converts certain values to a defined value |
Expression | Perform complex calculations using logic |
Expression type | The format the result of the above expression shows as (e.g. Date, Time, String, Binary) |
Group By Expression | Groups the report by the output of the above expression |
Column Group - Use Case
Columns in the report can be grouped together by entering a column group name in this field.
Entering the same name in other columns will group multiple columns together.
In the example below, entering "Course Date Details" into the column group for the first four fields and "Candidate Details" for the last two groups the fields together like so:
Width - Use Case
Although columns in report writer do extend to show the values they hold, columns can be set at a fixed width.
The value needs to be entered in pixels (px) or points (pt)
URL - Use Case
Values in reports can be converted into a hyperlink which can help to provide links to web pages or pages within accessplanit.
This can be done by entering the URL for the page in accessplanit along with the wildcard to enter the report value into the URL.
The URL for a page can be found by opening the page in a new tab. The URL for that page appears in the browser.
In the example below, a basic course date details report can be altered to give a link directly to the course date in accessplanit:
First, navigate to a course date and open the course date in a new tab.
The URL details the unique reference for the course date (coursecalid) at the end of the URL: https://matt.accessplanit.com/accessplan/futureplan/pagehost.aspx?phid=203&id=12432
Having the field "coursecalid" in the report allows you to enter a URL against this field that will add the coursecalid in the URL.
Following the same format as the URL, replacing the coursecalid with the wildcard will change the coursecalid into a hyperlink:
https://matt.accessplanit.com/accessplan/futureplan/pagehost.aspx?phid=203&id={1}
Text Highlight - Use Case
Text highlight can be used to change the colour of certain values within the column.
First, specify the value, then after using a colon, specify the colour.
Multiple values can be changed at the same time by separating each change with a semi colon
Cell Highlight - Use Case
Much like text highlight above, the same principle can be used to change the colour of cells in a column that match certain criteria.
First, specify the value, then after using a colon, specify the colour.
Multiple values can be changed at the same time by separating each change with a semi colon
Value Ranges - Use Case
Value ranges uses the same principle as the two highlighting methods above. However, this is used to convert one value into another.
First, specify the value, then after using a colon, specify the Value you would like to show instead.
Multiple values can be changed at the same time by separating each change with a semi colon.
In the example below, the Venue Country field has been altered to convert the value "United Kingdom" into "UK"
