MIS Systems Thread, SIMS Attendance by class code in Technical; Good afternoon,
I am required to analyse the attendance of last years booster classes. I have tried to create my ...
24th September 2013, 01:51 PM #1
- Rep Power
SIMS Attendance by class code
I am required to analyse the attendance of last years booster classes. I have tried to create my own report but cannot seem to do it successfully. Then I saw the SIMS report called "Lesson Attendance by Classes" located via Reports > Lesson Monitor > Whole Group Student Reports.
The problem with this report is I cannot output it to Excel so that I can create a pivot table.
Any advice will be hugely appreciated.
IDG Tech News
24th September 2013, 04:16 PM #2
When you print, instead of the default choose to save as a file, and choose type .xml - it's not excel-ified, but you can force it to open in Excel if you suppress the errors and it's not bad.
Or, accept the default output to webpage then copy and paste the data to Excel, usually works well with only minor adjustments needed.
24th September 2013, 04:35 PM #3
- Rep Power
I tried the copy and paste but unfortunately it needs a lot of editing. I will try the XML version
Originally Posted by vikpaw
By apeo in forum MIS Systems
Last Post: 3rd November 2012, 07:11 AM
By syc in forum MIS Systems
Last Post: 3rd October 2012, 07:49 PM
By ful56_uk in forum MIS Systems
Last Post: 3rd October 2012, 09:14 AM
By DSapseid in forum MIS Systems
Last Post: 11th February 2012, 07:37 AM
By imiddleton25 in forum MIS Systems
Last Post: 10th January 2011, 03:13 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)