[sims] SIM's Individual Report

[Steven_Cleaver]

Hi

 

I am just wondering if the following is feasible in SIM's individual reports what I want to do is create a Student Report that can populate a Student, Teacher and Class for lessons so something like the below;

 

Student Name

 

Period1 Period2 Period3 Period4 Period5

ICT/Y1 Eng/Y1 Geog/Y2 RE/Y2 PE/Y2

J. Doe M.Brown T.Smith J.Jones H.White

 

So I am struggling to see how to sort of create Class Slots and associate this with whatever subject a student is doing. The idea of this is we can use it for refocus run this for the Students in Refocus and add what work needs to be completed for the students in Refocus for specific subjects.

[vikpaw]

Don't the student list reports do something like this if based on curriculum.

[Steven_Cleaver]

Hi Vik

 

 

Your right it is almost their using this method but not quite, have tried it three ways through Individual Reports, constructing Report from Scratch and as you said through Student List\Time Table and this is the closest and has the actual fields but what I am after is sort of Specific Student Classes with Teacher for Monday one Report, Specific Student Classes for Tuesday Second Report etc would sort of add blank boxes so they could just add info they would then just Print Individual Students for students in Refocus that's why I thought Individual Reports would be easy if that makes sense. I could as you say use Student List\Time Table and sort of hack this but as it is only going to be few different kids each day would be Time consuming. The other way I have just thought of is sort of exporting and Mail merging from Student List and they just select the Students and print those but this would possibly get out of date with new Students or Time Table changes saying that though I could possibly just export the data periodically and Mail Merge would update when run with new data what do you think. Just a shame I can't do this in Individual Reports as that would defiantly be the easiest way if I could link the Data how I needed.

 

Cheers Vic if you can think of anything else.

[vikpaw]

Can you use a UDG with student list reports? That would cut some hassle.

Otherwise, I have seen a report on classes, effectively bringing out the timetable to a CSV but it's not sorted in a table more like multiple rows so it would need parsing or putting into a a pivot table. This is out of the reporting engine, not Individual Reports but can be applied to a UDG I think.

[Steven_Cleaver]

Cheers Vic think have looked at the Classes Report you mean and this almost gets me there just not quite the format I want not sure what you mean by UDG though.

[vikpaw]

User defined group. Create a custom group with all your Refocus kids so you don't have to cherry pick and can run a report against them.

[vikpaw]

If you need it to be an Ind. Rep. cos you want to merge aspects in then it's gonna be hard, if you just want the data out, kind of like you showed, you can do a report similar to below and just transpose the rows to columns, and manipulate as required. It's filtered on a User Defined Group, so you can add all your refocus kids to that first, and could also do extra run time filtering on the day if it helps.

 

You can see it, but there is a sub-query on the group membership table.

[Steven_Cleaver]

Cheers Vic had the first bit but the Lessons bit pointed me in the right direction and gave me idea so below almost gets me their and use Filtered report and enter at Runtime so they can enter student name, day and have used Define sort order on the filter and use and remove tick from Include Record with no such lessons, gets me student with lessons for just that day in reasonable format, see below.

 

[Steven_Cleaver]

Then having a quick look might try Mailmerge output and see if I can create report using this method and add the blank fields etc.

[vikpaw]

That should work. If you will only do it a student at a time, it's more efficient to use a filter based on admission no. and either get them to look it up first, which is quick (quicksearch), or have a ready reckoner to hand for all the refocus kids. Makes life easier, especially if you have a lot of Dave Smiths.

Mailmerge is a good idea hope it works out.

[Steven_Cleaver]

Cheers Vic will give this a go and thanks for your help much appreciated as always