Using ReportWorks

1. Using ReportWorks Dori Baldwin Student Info Mgmt Coordinator Kent ISD

2. Agenda • Welcome & Introductions • Objectives • Introduction to ReportWorks • Create Labels • Create Student Schedules • Create Cross Tab Reports • Create Form Letters

3. Objectives Upon completion of today's training you will be able to: • Explore an existing report • Setup mailing labels with a logo • Create a list of student’s demographic information • Create a Cross Tab Report • Write form letters

4. Meet the Trainers • Been with the ISD 11 years • Started in the classroom • On PowerSchool since 2001 • Certified PowerSchool Trainer Dori

5. Your Turn. . . .

6. ReportWorks Overview

7. Main features • Drag-and-drop interface – no more writing codes • Create report templates for other PowerSchool users to run without knowing SQL

8. Tools • The pages • The Inspector and thepanels

9. The Pages

10. Details Tab • Title of the report • Information about the report • Publish State • Choose Data Set • Student : Basic • Student : Basic + Schedule • New ones with 1.1

11. Scope Tab • Boundaries (filters) • Runtime Controls • Data Sets

12. Layout Tab • Drag and drop data objects (fields) • Preview Report

13. Publish Tab • Make the report available to other PowerSchool administrative users • Choose the format your users will see • Choose where the report will show in PowerSchool

14. The Inspector and the Panels

15. The Inspector • Changes with the level • Document • Page • Label • Text

16. The Panels • Used in conjunction with the inspector • Modifies format • Color • Font • Format

17. Getting Started

18. 2 Ways to Get There • Start from the PowerSchool Main Menu • Click ReportWorks • Click Reports  Setup  ReportWorks

19. Separate Application • JavaTM application

20. Template or From Scratch • Template • Provide frame work • Good starting place • Can be used as a starting point for staff • Scratch • Blank slate

21. Let’s go live . . . Activity 1 - Creating a Student Schedule from a Template

22. Creating Labels

23. Labels are a snap with ReportWorks • Sizes are already defined • Easier to add your own logo • Preview the labels before printing or saving

24. By the numbers Give your report a title Limit the data by setting Boundaries (Filters) Create the Initial Layout Choose the Label Type Arrange the data     

25.  Start and Name the Project  • From the PowerSchool main menu • Click ReportWorks • Launch • Select Project from scratch • Enter name and discription • From the Detail • Select the Student :Basic Data set   

26.  Setting Boundaries  • Boundaries limit or filter who the report will be run for • Use Data Set at the bottom to drag field into the boundaries area • Add the desired filter • Repeat as necessary   

27.  Create the Initial Layout  • In the Layout tab • Drag “Student” from the data set to the layout area • Select the labels report type   

28.  Choose the Label Type  • Open the Labels inspector • Under Avery Product number select 5160: Address Labels   

29.  Arrange the Data  • Double-click in the 1st label (upper left) • Drag Students > Contact > FirstLast Name into this label • In the Inspector, enter the LF or other text • Continue to drag fields into the label   

30. Let’s go live . . . Activity 2 – Create Mailing Labels Activity 3 – Add a Logo to your Labels

31. Student Lists and Demographic Reports

32. Basic Student List • Use a table to layout the fields • Drag the fields into the individual cells • Re-size the table to cover the entire page

33. By the numbers Start a new project Choose Table Arrange the fields in the table Click Standard > Add Alternate Use the Inspector to change the row color     

34.  Start a New Project  • Click “+ add” button and select to Add Project • Created as Untitled Project • Right click and Load • Click Details tab • Enter name and description • Select the Student :Basic Data set   

35.  Choose Layout Type  • In the Layout tab • Drag “Student” from the data set to the layout area • Select the Table report type   

36.  Arrange Fields  • Drag Students > Contact > Last Name into the 1st column • Continue to drag fields into the columns • First name • Ethnicity • Gender • Adjust column widths   

37.  Select Alternate Rows    

38.  Select Row Colors  • Click Student Details • Red box should be around all columns • In the Table Row Inspector • Click the paint can to open the Paint/Fill Inspector • Select the desired color   

39. Let’s go live . . . Activities 4 – 7 Create and format a Simple Student List

40. Cross Tab Report

41. Making Information out of Data • Similar to Pivot Tables • Counting the numbers of boys vs girls • Identify which class has the most diverse population • How many seniors are girls

42. Let’s go live . . . Activities 8-9 Create and format a Cross Tab Report

43. Label Layout Help • Open Microsoft Word • Under Mailings – Labels • When you pick a specific label you can view the details

44. Sample Labels

45. Now It’s Your Turn . . . Complete Activity 4 – Create a Mailing Label

46. Object Reports Create when your report requires: • Complete Control of Layout • Graphics • Multiple Pages per student • Multiple Students per page

47. Basic Report Elements Text and words