Jun 8, 2012 at 1:58 PM
Edited Jun 15, 2012 at 7:52 PM
We have just launched a SLK implementation on SP 2010 using custom "reporting". The SQL views are available on the link given below, and are implemented on SP using "BDLC" (Business Data List Connector) from Layer2.de, which is a more
flexible way of getting SQL data into Sharepoint. (It supports "Person/Group" fields for one, which allows you to filter results more effectively)
I am working on a detailed guide, both for internal use and for sharing with the SLK community. In the meantime I suggest you look at the SQL code and see what you can use. I expect the documentation to be done sometime next week.
The most interesting view is probably the "LMS Result View" which shows all the results in a grid. Ready for "Group By" first 'Assignment' and then 'Student'.
I decided to add 2 new Functions (GetInstructors and GetLearnerAssignmentStateText) and 1 new Table (ResultState) to make the views less complex.
Please give me any feedback you have. I'm currently working on documentation for BDLC, and then the "big one" where it all comes together.