Report Parameters
Report parameters determine the details included in a report and how that information is displayed. Parameters you set up and maintain in web view appear in database view (and vice versa).
To edit a report, select Edit from a report's menu or select the report name from the Reports list page.
Tip: Parameters vary depending on the report you select.
-
From the Reports list page, select Edit from a report's menu or select the report name from the Reports list page.
-
Under Headings, enter a title and subtitle, and specify the header alignment and format when printing.
-
Under Content, further define your report's format and the details to include when printing.
-
Under Format, select whether the report prints in Landscape or Portrait.
-
Under Sort, add, edit, and delete fields on the report. To add another sort, select Add another sort field. You can also manually drag and drop fields up and down using the row anchor .
-
Under Footers, enter the text you want to appear at the end of the report as well as the text for each page.
-
Under General, select the chart template and level to use. For more information about chart templates, see Chart Organizer.
-
Under Dates, select the dates you want to use to determine which transactions are included.
-
Under Columns, add, edit, and delete columns, or add a new one.
-
Under Multiple column headings, add, edit, and delete multiple columns, or add a new one.
-
Under Filters, specify filters or add new ones. You can filter your report based on selected criteria such as accounts, classes, and journals. For example, you can include only the accounts within a certain range. Accounts that are not within the range are excluded from the report.
-
In Statement body format, specify statement criteria.
-
In Change in fund balance section format, select how to display changes.
-
Under Number format, select how you want number and currency formats to appear in the report.
-
Select Save.
You can add, edit, and delete report columns from the Edit report parameters screen.
Tip: To edit, delete, copy, or move existing columns, select next to the column, and make your selection. Your choices include edit, copy all parameters, copy date parameters only, move up or down, and delete. You can also manually drag and drop columns up and down using the column row anchor .
-
From the Edit screen, select Add another column under Columns.
-
Under Copy settings, select the column settings you want to copy. The new column will have the same settings.
-
Under Definition, select "amount" or "description" for the column value type. If you select "amount," enter the calculations for that column. Select Validate to validate the expression.
-
Under Filters, enter the date or date range to include in the column. To add additional filters to the column, select Add a filter. You can filter the column based on selected criteria such as accounts, classes, and journals. For example, you can include only the accounts within a certain range. Accounts that are not within the range are excluded from the column.
-
Under Layout, specify the column heading and width, number format, and decimal places. If you select Hide this column on the report and export the report, hidden columns are not exported.
-
Select Save, or Save and new to add another column.
You can add a heading to cover more than one column.
Tip: To edit or delete existing columns, select next to the column, and make your selection. You can also manually drag and drop columns up and down using the column row anchor .
-
From the Edit screen, select Add another multiple column heading under Multiple column headings.
-
Enter the start column and end column for the heading to appear above, and specify alignment.
-
Select Save, or Save and new to add another column heading.
You may need to save a personal copy of the parameters to add security for future use.
-
From the Edit report screen, select Save as.
-
Enter the report name and description for the parameter file, and specify whether or not other users can run or modify the report.
-
Select Save.