Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
hnorman

Multiple Student Object Report

hnorman
Practitioner
‎05-21-2021 06:05 AM
‎05-21-2021 06:05 AM

Multiple Student Object Report

Does anyone have a template for an object report that we could run as a field trip or class roster? We would want it to contain student info, contact info, Allergies, and Medical Alerts.  Field Trip Roster.PNG

1 Solution
hnorman
Practitioner
‎05-21-2021 11:44 AM
In response to HeatherWeist
‎05-21-2021 11:44 AM

Thank you so much for all of your help. I edited the code, and was able to get exactly what we needed:

 

<tabl 2><b>^(first_name) ^(last_name)</b><tabl 4><b>Date of Birth:</b> ^(DOB)
<tabl 2.15>^(street)<tabl 4><b>Father:</b><tabl 6><b>Mother:</b>
<tabl 2.15>^(city), ^(state) ^(zip)<tabl 4.15>^(father)<tabl 6.15>^(mother)
<tabl 2><b>Home Phone:</b><tabl 4.15>^(StudentCoreFields.fatherdayphone)<tabl 6.15>^(StudentCoreFields.motherdayphone)
<tabl 2.15>^(Home_Phone)<tabl 4><b>Emergency Contact:</b><tabl 6><b>Emergency Contact Phone:</b>
<tabl 2><b>Allergies:</b><tabl 4.15><tabl 4.15>^(Emerg_Contact_1)<tabl 6>^(Emerg_Phone_1)
<tabl 2.15>^(StudentCoreFields.allergies)
<tabl 2><b>Medical Alert:</b>^(Alert_Medical)
<tabl 2><b>Guardia Alert:</b>^(alert_guardian)

 

View solution in original post

8 Replies
HeatherWeist
PowerSchool Mentor
PowerSchool Mentor
‎05-21-2021 07:28 AM
‎05-21-2021 07:28 AM

I have one that might work...Here is the code. It will need to be saved as a .pst and imported into PS. 

 

<PSReportTemplate>
 
<FileHeader>
<Created>Mon, 1 Dec 2014 18:47:43 GMT</Created>
<PSVersion>8.1.0.0.1012250</PSVersion>
<TemplateVersion>1.0</TemplateVersion>
<Author>z23, 23</Author>
</FileHeader>
 
<ReportHeader>
<Type>Object Report</Type>
<Name>Trip Roster w/ Photos</Name>
<Table>Students</Table>
</ReportHeader>
 
<ReportData>
<Units>Inches</Units>
<Paper>
<Size>Letter</Size>
<Width>8.5</Width>
<Height>11</Height>
<Orientation>Portrait</Orientation>
<Margins>
<Left>1.25</Left>
<Top>1.25</Top>
<Right>1.25</Right>
<Bottom>1.25</Bottom>
</Margins>
<Scale>100</Scale>
</Paper>
<Body>
<Font>
<Face>Palatino</Face>
<Size>10</Size>
<Leading>13</Leading>
</Font>
</Body>
</ReportData>
 
<ObjectData>
<Type>Objects</Type>
<Object no="1">
<Type>Line</Type>
<Label>.001.Dividing Lines</Label>
<Page></Page>
<Layer>0</Layer>
<Repeat>
<Multiple>6</Multiple>
<Offset>
<Horizontal>0</Horizontal>
<Vertical>1.5</Vertical>
</Offset>
</Repeat>
<Coordinates>
<Left>0.5</Left>
<Top>1</Top>
<Right>8</Right>
<Bottom>1</Bottom>
</Coordinates>
<Line>
<Width>1</Width>
<Style>1</Style>
<Color>Black</Color>
</Line>
</Object>
<Object no="2">
<Type>Text</Type>
<Label>.002.Header</Label>
<Page></Page>
<Layer>0</Layer>
<Coordinates>
<Left>0</Left>
<Top>0.75</Top>
</Coordinates>
<MaxWidth>0</MaxWidth>
<MaxHeight>0</MaxHeight>
<Body>
<Font>
<Face>Default</Face>
<Size>18</Size>
<Leading></Leading>
</Font>
<Text>&lt;tabc 4.25&gt;Field Trip Roster</Text>
</Body>
</Object>
</ObjectData>
 
</PSReportTemplate>

 


Heather Weist, MEd
PowerSchool - SIS Administrator, Commonwealth Charter Academy

PowerSchool Mentor/Champion

PowerSchool Mentor of the Year 2021 Winner

PowerSchool Beta Tester of the Year 2022 Winner


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
0 Kudos
hnorman
Practitioner
‎05-21-2021 08:14 AM
In response to HeatherWeist
‎05-21-2021 08:14 AM

Thank you! That worked for the formatting, now I just need to get the student name/medical info in there as well. 

Capture.PNG

HeatherWeist
PowerSchool Mentor
PowerSchool Mentor
‎05-21-2021 08:23 AM
In response to hnorman
‎05-21-2021 08:23 AM

@hnorman 

 

Try this for the text...

 

<tabl 2><b>^(first_name) ^(last_name)</b><tabl 5><b>Allergies:</b>
<tabl 2.15>^(street)<tabl 5.15>^(allergies)
<tabl 2.15>^(city), ^(state) ^(zip)<tabl 5><b>Emergency Contact:</b>
<tabl 2><b>Home Phone:</b><tabl 5.15>^(Emerg_Contact_1)
<tabl 2.15>^(Home_Phone)<tabl 5><b>Emergency Contact Phone:</b>
 <tabl 5.15>^(Emerg_Phone_1)


Heather Weist, MEd
PowerSchool - SIS Administrator, Commonwealth Charter Academy

PowerSchool Mentor/Champion

PowerSchool Mentor of the Year 2021 Winner

PowerSchool Beta Tester of the Year 2022 Winner


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
0 Kudos
HeatherWeist
PowerSchool Mentor
PowerSchool Mentor
‎05-21-2021 08:33 AM
In response to HeatherWeist
‎05-21-2021 08:33 AM

See attached additional instructions!


Heather Weist, MEd
PowerSchool - SIS Administrator, Commonwealth Charter Academy

PowerSchool Mentor/Champion

PowerSchool Mentor of the Year 2021 Winner

PowerSchool Beta Tester of the Year 2022 Winner


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
Preview file
15 KB
hnorman
Practitioner
‎05-21-2021 11:44 AM
In response to HeatherWeist
‎05-21-2021 11:44 AM

Thank you so much for all of your help. I edited the code, and was able to get exactly what we needed:

 

<tabl 2><b>^(first_name) ^(last_name)</b><tabl 4><b>Date of Birth:</b> ^(DOB)
<tabl 2.15>^(street)<tabl 4><b>Father:</b><tabl 6><b>Mother:</b>
<tabl 2.15>^(city), ^(state) ^(zip)<tabl 4.15>^(father)<tabl 6.15>^(mother)
<tabl 2><b>Home Phone:</b><tabl 4.15>^(StudentCoreFields.fatherdayphone)<tabl 6.15>^(StudentCoreFields.motherdayphone)
<tabl 2.15>^(Home_Phone)<tabl 4><b>Emergency Contact:</b><tabl 6><b>Emergency Contact Phone:</b>
<tabl 2><b>Allergies:</b><tabl 4.15><tabl 4.15>^(Emerg_Contact_1)<tabl 6>^(Emerg_Phone_1)
<tabl 2.15>^(StudentCoreFields.allergies)
<tabl 2><b>Medical Alert:</b>^(Alert_Medical)
<tabl 2><b>Guardia Alert:</b>^(alert_guardian)

 

jshoaf
Journeyman
‎02-18-2022 08:22 AM
‎02-18-2022 08:22 AM

Is there a report to run and get a list of all students with medical alerts in? I do not see this on the options for system reports.

Thanks!

0 Kudos
ParitoshT
Community Support Expert
Community Support Expert
‎02-21-2022 11:13 AM
In response to jshoaf
‎02-21-2022 11:13 AM

Hi @jshoaf,

 

You should be able to get the list of those students along with their medical alerts through Quick Export. You can follow the steps listed below

 

From the start page, type the following search:
Alert_Medical#

Using Group Function - Select Export

First_Name
Middle_Name
Last_Name
DOB
Grade_Level
Alert_Medical

 

OR

 

Navigate through Start Page > System Administrator > Page and Data Management > Quick Export 

 

ParitoshT_0-1645470971515.png

 

 

Please let me know if this helps or in case of further questions.

 

ParitoshT

Community Moderator 

 

Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!
 

 

 

 

 

0 Kudos
hnorman
Practitioner
‎02-22-2022 08:47 AM
In response to jshoaf
‎02-22-2022 08:47 AM

There are many reports to run!

If you want to grab which students have health alerts, one of the easiest ways is going to be searching alert_medical#. This will pull all of the students with something in the medical alert field, then you can export that data any way you like!

 

hnorman_1-1645548238305.png

 

 

 

  1. Quick Export- select which field you want
  2. Templates for Exporting- You can create what you would like to run. 
  3. Print Reports-This is where I have created an object report that has pictures of students and their emergency/medical information as a class roster for teachers.
  4. PSCB Custom Reports
  5. Data Export Manager- any detailed report you would like. Office visits, immunizations, medications, etc.
  6. hnorman_2-1645548379542.png

     

0 Kudos
Related Discussions & Articles