Creating or Modifying a Custom Report or Inquiry
Screen ID: | n/a | |
Screen Title: |
Build a Report |
|
Panel ID: | WRKQRY01 | |
Tool Number: | 100 | |
Click here to magnify |
Access this screen by selecting Tool #100 CU*BASE Report Builder (Query) (Shortcut: query).
Check out the video related to this topic: Formatting Dollar Amounts (More videos below!) |
Helpful Resources
CU*BASE Report Builder (Query) Overview
Learn how to complete Query-related tasks in CU*BASE.
Screen Overview
This is the first screen used to create, modify or run custom reports and inquiries created using the CU*BASE Report Builder. This starting screen is used to choose the report name to be created or modified. Use the drop-down list to choose an Option (described below). Fill in both a Name and Location. Use Enter to proceed.
Field Descriptions
Field Name |
Description |
Option |
Create (1) - Use this option to create a new custom report or inquiry. Change (2) - Use this option to change an existing report configuration. Copy (3)- Use this option to copy an existing report configuration, either by assigning a different name or copying to a different location. Delete (4) - Use this option to delete a custom report you no longer need. One confirmation screen will appear. Display (5) - This option will display the settings for an existing report, but will not allow any changes. Print report definition (6) - Use this option to print the report configuration, showing all of the settings used in your report. This is helpful as a documentation of what files are included, the selection and sort settings, and any formatting you defined, in case you ever need to recreate the report or verify what settings were used to obtain the data. Run in job queue (8) - This option will run the report using batch processing, which reduces the resource drain on the system. This is the recommended method for running a custom report that is set up to output to a printer. Run (9) - This option will run a custom report interactively. Use this for reports that are set up to output to the screen (display) or a database file. This method is not generally recommended for printed reports. |
Name |
Report Builder report names must begin with an alphabetic character, with a maximum of 10 characters in the name. Valid characters: A through Z, 0 through 9, $, #, @, ., or _
|
Location |
With only a few specific exceptions, all custom reports and inquiries you create using Report Builder should be stored in the following library (in place of the xx, substitute your credit union's two-character CUID): QUERYxx The system will automatically show the name of the library used the last time a custom report was created or modified. |
Additional Video Resources
Check out these additional video resources! |
Visit the CU*BASE Video Library to view more CU*BASE how-to videos.