The topics in this chapter describe ways you can customize your SuperDB data. For instance, you can filter and save data as a Group and access that same group of students in other Administrator's Plus modules, such as AP Notify or Attendance.

You can also create and save Views that allow you to save your filter and sort preferences for a SuperDB table. When generating a SuperDB report, you can include a View so that the SuperDB table displays in the report with your filter and sort preferences.

TABLE OF CONTENTS

• Filter and Save Data as a Group
• Create a View of a SuperDB Table
• Use a View in Report Writer

Filter and Save Data as a Group

Filter and save data as a Group to access it anywhere in Administrator's Plus, similar to any other saved Group within the program. Saving a Group gives you quick access to that same group of students in other areas of Administrator's Plus, such as AP Notify or Batch Entry in the Attendance module.

Note: A Group is different from a View. A Group contains a set of students, whereas a View contains the filter and sort customizations you've applied to a SuperDB table.

1. On the menu bar, click View > SuperDB.

2. Click a table from the drop-down list at the top of the SuperDB dialog box.

3. Click (All) at the top of a column, and click the desired filter option from the drop-down list.

Note: The filter options are (All), (Custom), (Blanks), (NonBlanks), and all other field entries in that column.

Tip: If you choose to create a (Custom) filter, set your preferences in the Custom AutoFilter dialog box, and click Done.

4. Click Save as Group at the bottom of the left panel.

5. Enter a Group name, or click a previously saved Group from the drop-down list to overwrite that Group with this newly saved data.
6. Click Save.

Create a View of a SuperDB Table

A View saves your filter and sort preferences for a specific table. For example, if you create a table with students’ college application data, and filter the table by who has completed their FAFSA, you could save the View as “FAFSA Yes.” The next time you want to access this information, you can choose the “FAFSA Yes” View instead of manually filtering the data. A View can be printed, exported to Excel, added to a Report Writer report for a report card, transcript, or other report, or saved as a group.

1. On the menu bar, click View > SuperDB.

2. Click a table from the drop-down list at the top of the SuperDB dialog box.

3. Click (All) at the top of a column, and click the desired filter option from the drop-down list.

Note: The filter options are (All), (Custom), (Blanks), (NonBlanks), and all other field entries in that column.

Tip: If you choose to create a (Custom) filter, set your preferences in the Custom AutoFilter dialog box, and click Done.

4. Optional: Right-click a column you want to hide, and click Hide This Column.

5. Click Save View in the left panel.

6. Enter a name for this View, and click Save As.

Tip: After you've created a View, you can access it by clicking the drop-down list at the upper-right corner of your SuperDB dialog box.

The following are additional tasks you can perform with your new View:

Use a View in Report Writer

When creating a report in Data Base Report Writer, you can include a SuperDB table with a View in the report. The View displays the table in your report using your filter and sort preferences. If you're printing a report and want to display a table with hidden columns, you can include a specified View that hides any columns that you don't want to include in the report. For example, you can use this process to create a report card by entering grades into a SuperDB table, saving your filtered and sorted data as a View, and inputting that View in the Report Writer.

1. In Data Base, click DB RW.
2. In the Specifications: Data Base Report Writer dialog box, configure the following settings:

• Active Letter/Report: Click next to the text box, click your desired report, and click Select.

Note: You can click any report that you want to generate.

• Include Active/Inactive Status: Click Active Students Only, Active and Inactive Students, or Inactive Students Only, depending on which type of students you want to include.
• Include Blank Search/Sort Categories: Click Include to include blank entries, or click Do NOT Include to only show entries with data.
• Start Grade For All Grades: Click the beginning grade where you want to start your report in the drop-down list.
• End Grade For All Grades: Click the last grade where you want to end your report in the drop-down list.
• Print Preview: Choose whether or not you want to view a print preview of your report.
• Date for Age Calculation: Click   to set the date as of which you want to calculate ages.

Tip: Set today's date if you want to know the ages of students today.

• Print Field Name or Description: Click Name to include the field name, or click Description to include the field description.

3. Click Done.
4. Click View/edit letters/reports, and click Next.

5. In the Viewing and Editing Data Base Reports/Letters dialog box, click Select.

6. In the Data Base code writer, scroll down to the bottom of the code, place your cursor at the end of the last row, and press Enter on your keyboard.

7. Click the Report Key Words [ALT + X to select] drop-down list, and click ENDPAGE | Start a new page (BY ITSELF).

8. Place your cursor after  ~ENDPAGE~, and press Enter on your keyboard to skip to the next line.
9. Click the Report Key Words [ALT + X to select] drop-down list, and click SuperDB Table | SuperDB Table.

10. Click the SuperDB table with the View that you want to add to this report, and click Select.

11. Click Accept at the lower-right corner.

12. Click All grades combined, and click Next.

13. Click All students alphabetically, and click Next.

14. Click Print [F9].

SuperDB Table Report Writer Codes

The following table is provided to help you understand the Report Writer codes for SuperDB tables: