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.
- In Data Base, click DB RW.
- 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.
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.
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.
- Click Done.
Click View/edit letters/reports, and click Next.
In the Viewing and Editing Data Base Reports/Letters dialog box, click Select.
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.
Click the Report Key Words [ALT + X to select] drop-down list, and click ENDPAGE | Start a new page (BY ITSELF).
- Place your cursor after ~ENDPAGE~, and press Enter on your keyboard to skip to the next line.
Click the Report Key Words [ALT + X to select] drop-down list, and click SuperDB Table | SuperDB Table.
Click the SuperDB table with the View that you want to add to this report, and click Select.
Click Accept at the lower-right corner.
Click All grades combined, and click Next.
Click All students alphabetically, and click Next.
- Click Print [F9].
The following table is provided to help you understand the Report Writer codes for SuperDB tables:
|~SuperDBDefStart = 1~||Name the table code that follows. If you have another SuperDB table in this report, you would name it 2.|
|Box Width = AUTO||Set the width of the SuperDB table in inches. The default is AUTO.|
|Box Height = AUTO||Set the height of the SuperDB table in inches. The default is AUTO.|
|Row Height = AUTO||Set the height of the SuperDB table rows in inches. The default is AUTO.|
|Title Height = AUTO||Set the height of the SuperDB table title in inches. The default is AUTO.|
|TableName= SAT||Display the name of the SuperDB table. This table is named SAT.|
|ViewName= Test Score View||Set the SuperDB table View. This View is called Test Score View.|
|PrintEachStudentInSeparatePage =Y||Determine if each student's table prints on a separate page. This default is Yes.|
|WhichStudents=AsInFilter||Determine if only students included in the current View are printed or if all students included in the report are printed. The default is AsInFilter.|
|SuperDBTableTitle=TABLE: ~TableName~ View: ~ViewName~ ~CR~Filter: ~Filter~||Print the title of the table which, by default, consists of the table name, the View name, and the filter name.|
|PrintGrid=Y||Determine if lines are printed between columns and rows. The default is Yes.|
|PrintColumnHeaderandFont = Y||Determine if the column headers print and what the font and font size for the column headers are.|
|PrintBodyandFont = Y||Determine if the body of the table prints and what the font and font size for the body are.|
|ColumnHeaderHeight=0.2||Set the height of the column header in inches. The default is 0.2.|
|ColumnHeaderAlignment= CENTER||Align the column header text. The default is CENTER.|
|PrintColumnHeaderBorder = Y||Determine if a border prints around the column headers. The default is Yes.|
|TitleBorder = Y||Determine if a border prints around the table title. The default is Yes.|
|ExportSuperDBTable=N||Export the SuperDB table to an ASCII file if set to Yes. The default is No.|
|ExportFileName =||If you're exporting this table to an ASCII file, use this code to enter the path and the file name of the export destination.|
|~SuperDBDefEnd~||Signify the end of the SuperDB Table Box Code.|
|~PrintSuperDBTable=1, Left=0, Top=0.5~||Determine which SuperDB table to print and how many inches from the left and top margins to align the table.|