Triva isn't available right now.
Check out the support page for our phone number and hours
Custom Report Layout dialog (Data Mining)
Show all expandable content
Use this dialog to select search criteria, client information, and client contact information as report column headings and to format and preview a custom report.
To open this dialog, select the Edit button in the Custom Reports dialog or select the Continue button in the Add Custom Report dialog.
note
Tips
- The custom report shows only the types of data you select as column headings, regardless of the search criteria used in the most recent search.
- The custom reports that you design become available as report templates in the Add Custom Report dialog.
Fields & buttons
Report name
To change the name of the custom report, highlight the text in this field and enter the new name for the report.
note
Each report for the selected client database (for example, 1040 Individual) must have a unique name.
Presentation group box
Product
Select the federal or state application that corresponds to the search criteria you want to add as column headings in this report, or select General to add client information or contact information as column headings in this report.
note
If you select a federal or state application, the entity is determined by the database you selected from the Database menu in the Data Mining window.
Calculated value
To add a calculated value from the federal or state return as a column heading in this report, select federal or a state from the
Product
field, and then select this option.note
- This option is available only if you select a federal or state application from theProductfield.
- The criteria listed in the Name calculated list are determined by the database you selected in the Data Mining window and the application you selected in theProductfield in this dialog.
Input screen field
To add data from a federal or state input screen as a column heading in the report, select federal or a state from the
Product
field, and then select this option to enable the Select Field button, which you can use to select the desired input screen field.note
This option is available only if you select a federal or state application from the
Product
field.Select Field
Select this button to add input screen or statement dialog fields as a column heading in the report. Selecting this button opens the Input Screen Field Selection dialog, in which you can select the fields you want.
note
This button is available only if you select the
Input& screen field
option.Columns in layout
This pane lists the general information, calculated values, and/or input screen fields that you selected as column headings for the custom report.
note
- For each column heading, this list shows the application from which the heading was selected and the column heading description.
- For input screen fields, this list also shows the input screen from which the field was selected.
Move Up
Select this button to reposition the highlighted column, moving it one position to the left in this custom report.
note
A change made to a column's position is immediately reflected in the Preview pane at the bottom of this dialog.
Move Down
Select this button to reposition the highlighted column, moving it one position to the right in this custom report.
note
A change made to a column's position is immediately reflected in the Preview pane at the bottom of this dialog.
Field length
Select the up and down arrows to change the length of the field for the highlighted column.
note
- This field is available only if the highlighted column is for a description or text field.
- A change made to a field's length is immediately reflected in the Preview pane at the bottom of this dialog.
Name list
Highlight an item in this list and choose the Select button to add the item as a column heading in the report.
- This pane lists calculated values if you selected a federal or state application from theProductfield and selected theCalculated valueoption. (The calculated value criteria listed are determined by the database you selected in the Data Mining window and the application you selected from theProductfield.)
- This pane lists client and contact information if you selected General from theProductfield. (Client and contact information transfers to the custom report from data you have entered in input screens and in the File then New Client or File then Client Properties dialog.)
note
Items added to the custom report are reflected in the Preview pane at the bottom of this dialog.
Preview group box
Preview
Shows how the selected report will appear when printed. Any changes you make to the report layout are immediately reflected in this preview.
note
The custom report automatically shifts from portrait to landscape to export format as necessary, depending on how many columns you add and/or how large the font size and field length is for each column. If you created any custom reports that include more columns than will fit in a landscape layout, the page orientation switches to export. Export reports cannot be printed. They can only be used to export search results to a file for use with other applications.
Font size
Shows the selected font size (8-12 points) for all of the columns in this custom report. To change the font size, enter a different number or select the arrows to increase or decrease the number.
note
A change made to the font size is immediately reflected in the Preview pane at the bottom of this dialog.
Page orientation: portrait, landscape, or export
Shows the current page orientation for the selected report. As you make changes to the report layout, the orientation automatically shifts from portrait to landscape to export, as necessary.
note
If you select more columns than will fit in a landscape layout, the page orientation switches to export. Export reports cannot be printed and can only be used to export search results to a file for use with other applications.
Sort
Select which columns are primary and secondary, and whether you want the information displayed in ascending or descending order. In addition, when you create a report that includes input screen fields, you can mark the
Subtotal
checkbox to view the subtotal on the report.Related topic:
Data Mining overview