1 / 63

Using ReportWorks

Using ReportWorks. Dori Baldwin Student Info Mgmt Coordinator Kent ISD. Agenda. Welcome & Introductions Objectives Introduction to ReportWorks Create Labels Create Student Schedules Create Cross Tab Reports Create Form Letters. Objectives .

tauret
Download Presentation

Using ReportWorks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related