Tailor your report’s Colours, border Colours, locations, and more to your organization’s needs using Advanced Column Settings. In essence, you will be designing the cosmetics of the report, so the information displays how you want to see it.
Additional Information
Don’t have a report created yet? Check out the Report Designer Overview and Creating New Reports - The Basics.
Once you’re ready to get started, you’ll need to open the report in Report Definitions in the Avanti Desktop, if it’s not open already. By default, this can be found in Report Designer.
Select a column by clicking on it, then adjust its Advanced Settings. If you are unsure of what the setting is referring to, click on the setting name and the system will provide you with a brief description at the bottom of the Advance Column Settings area.
Additional Information
Do you need to adjust the columns’ order, column format, or make columns invisible? Check out Column Settings in Report Designer to learn more.
Auto Fill
Use Auto Fill to adjust a column's width to fill the free space remaining in the report. If you turn on Auto Fill for more than one column, each of the columns will be the same width, filling the free space.
Body Colour
Body Colour allows you to choose the colour of the body text for the selected column. This will impact the column’s body Colour on both the Report Definition and the generated report.
Body Font
Use Body Font to update the font in the body of the selected column. This will impact the column’s font on both the Report Definition and the generated report.
Body Wrapping
Body text will wrap across multiples line when Yes is selected; otherwise the text will be truncated.
Border and Border Colour
If None is selected as the border, the body text will not have any borders. However, you can select a border from a variety of different combinations. In addition, the Border Colour setting will determine in which Colour the border will appear.
Custom Column Format
Looking to format your column and don’t see the right option in Column Format in Column Settings? There may be a Custom Column Format that will work for you. Reach to Client Care if you’re interested in learning more.
Header Border and Border Colour
If None is selected as the border, the header text will not have any borders. By default, this is set to Bottom. However, you can select a border from a variety of different combinations. In addition, the Header Border Colour setting will determine in which Colour the border will appear.
Header Colour
Select the colour you’d like for the column’s header text. This adjusts the column’s header colour on both the Report Definition and the generated report.
Header Column Span
Use the Header Column Span to replace the column headers to the right of the column. You’ll want to use this when a column’s header applies to two, or more, columns in sequence.
The number of header columns for the current header columns body to span across. Spanning a header column will always replace the columns immediately to the right of the select column.
Header Font
Header text font for the selected column. This will impact the column’s header font on both the Report Definition and the generated report.
Header Wrapping
Header text will wrap across multiples line when Yes is selected, otherwise the text will be truncated.
Left and Right Column Margin
Controlled by two separate settings, the column’s left and right margins can be defined by the Left Column Margin and Right Column Margin, respectively.
Margin Ignore Borders
Controls whether the margins applied using the Left Column Margin and Right Column Margin settings appear within the column’s borders or outside of them. If set to Yes, the column’s margins will be applied outside of the selected column’s border.
Looking for more ways to perfect your report? Take a look at:
Column Settings to adjust the columns’ order, column format, and even make columns invisible.
Sorting Reports if the information isn’t in the order you’d like.
Styling Reports to add colours, display borders, adjust margin size, and set the fonts on your report.
Filtering a Report for details about preventing some information from being included in the report.
Formula Driven Report to perform calculations using data from other columns.
Include Your Report on the Avanti Self-Service Portal to add your finished report to ASSP for others to use.