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 Three Dots next to the text box, click your desired report, and click Select.

      Report Specifications

      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 Three Dots to set the date as of which you want to calculate ages.

      Set Age Calculation

      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.

    View Edit Reports

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

    Family Letter Selection

  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.

    Blank Space For Enter

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

    Endpage Code

  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.

    SuperDB Code

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

    View Selection

  11. Click Accept at the lower-right corner.

    Accept

  12. Click All grades combined, and click Next.

    Grades Combined

  13. Click All students alphabetically, and click Next.

    Students Alphabetically

  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:

SuperDB Code Explanation
~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.

This topic was last updated on February 08, 2018.


Rediker Software, Inc., 2 Wilbraham Road, Hampden, MA 01036
Copyright © 2018 Rediker Software Inc. All rights reserved.

Copyright © Rediker Software, Inc. All rights reserved.