To create a custom report card, you export the appropriate fields from Registrar's Office and then create the report in Crystal Reports.
Following are the steps to get you started. Please note that this solution does not contain every step needed for a complete report card. To learn more about Crystal Reports, review Crystal Report FAQs.

  1. Export Fields from Registrar's Office
    1. On the Export page, click New on the action bar
    2. On the Create a New Export screen, select Student
    3. In the Export format field, and select Blackbaud Report Writer Database (MDB)
    4. Click Create Now
    5. On the New Student Export screen, on the Filters tab, filter the students as appropriate. For example, include only students in the 9th grade with the status Current Student.
    6. Select the Output ta. 
    7. Expand the Student category, and select the Student name field
    8. Expand the Grades category and the Grades/Skills subcategory
    9. Select the Grade field
    10. On the Grades/Skills screen, on the General tab, leave the first field blank and accept the default in the second field

       

    11. Select the Filters tab

       

    12. Filter the students as appropriate. For example, include only one school, academic year, session, and marking column set.
    13. Click OK
    14. In the Grades/Skills subcategory, select the Marking column, Academic year, and Awarded Credit fields
    15. In the Grades/Skills subcategory, expand the Course subcategory
    16. Select the Course ID and Course name fields
    17. In the Grades/Skills subcategory, expand the Classes subcategory, expand the Information Scheduled subcategory, and expand the Teachers subcategory
    18. Select the Faculty Name field
    19. Select File, Save from the menu bar
    20. Name and save the file
    21. Select File, Export from the menu bar
    22. On the Export file name screen, select the export folder 
    23. In the File name field, name the export file
    24. Click Save
    25. Select File, Export from the menu bar
    26. On the Export file name screen, in the Save in field, select the folder for the export file
    27. In the File name field, name the file
    28. Confirm the Save as type field displays Blackbaud Report Writer Database (MDB)
    29. Click Save
  2. Create a New Report in Crystal Reports 8.5
    1. Open Crystal Reports version 8.5
    2. On the Welcome screen, mark As a Blank Report

       

    3. Click OK
    4. On the Data Explorer screen, expand the Database Files folder
    5. Double-click Find Database File
    6. Search for and select the MDB file created above
    7. Note the Data Explorer screen now lists the MDB file

       

    8. Press and hold Shift and select all tables listed below the file, such as Sts, StsGrds, and StsGrdsGrds_1
    9. Click Add 
    10. Click Close

       

    11. On the Visual Linking Expert screen, click Tables
    12. In the Unlinked Tables frame, move all tables from the Invisible Tables box to the Visible Tables box
    13. Click OK to return to the Visual Linking Expert screen
    14. Click OK
    15. Select Insert, Group from the menu bar
    16. On the Insert Group screen, select the arrow in the first field. Search for and select StsSt_StudentName.

    17. Click OK
    18. On the Design tab, right-click Group Footer #1 and select Format Section
    19. On the Section Expert screen, on the Common tab, mark the New Page After checkbox

       

    20. Click OK
    21. Select Insert Group from the menu bar
    22. On the Insert Group screen, select the arrow in the first field. Search for and select StsGrdsGrds_1Crse_CourseID.

       

    23. Click OK 
    24. Right-click Group #2 Name and select Delete

       

    25. Select Insert, Field Object from the menu bar
    26. On the Field Explorer screen, expand the Database Fields category

    27. Select the StsGrdsGrds_1Crse_Coursename field and use your cursor to place it in the Group Footer #2 row 
    28. Use your cursor to widen the Group Footer #2 row
    29. Select the StsGrdsGrds_1Clss_1InfSchdTchrs_1_Fclty_Stffmmbrnm field and use your cursor to place it below the StsGrdsGrds_1Crse_Coursename field in the Group Footer #2 row
    30. Create a formula that displays the grade for a selected marking column. For example:
      If {StsGrdsGrds_1.StsGrdsGrds_1_Markingcolumn} = "SEM 2" then {StsGrdsGrds_1.StsGrdsGrds_1_Grade} 
    31. Create a formula that displays the credits earned for a selected marking column. For example:
      If {StsGrdsGrds_1.StsGrdsGrds_1_Markingcolumn} = "SEM 2" then {StsGrdsGrds_1.StsGrdsGrds_1_Awardedcredit} 
    32. Create formulas for all other marking columns you want displayed on the report card and place them in the Detail Section
    33. Right-click on each of the formula fields and select Insert, Summary. Choose the Maximum operator and Group #2 and click OK
    34. Create summaries for all other marking columns formulas
    35. Right-click on Details and select Suppress (No-Drill Down). Do the same for Group Header #1 
To inquire about our Custom Report Writing Services, contact your account manager at solutions@blackbaud.com.