Tuesday, July 10, 2012 7:51 AM
Good day all,
Please i am working on a students management system with SharePoint 2010 and SSRS. I used SSRS to create the students academic results for each session. And i want to use the records management feature in SharePoint to manage other records of the students (eg personal details, medical record, extra-curriculum activities record etc).
Since the students records comprises of several records including their academic result which is developed with SSRS, is there a way i can save these students SSRS generated academic results in the SharePoint record management system, thereby tying each student's result to their respective records.
Please i really need assistance on this.
Wednesday, August 01, 2012 6:39 PM
I see two different things in your request:
- First, the concept of regrouping everything related to a given student under a single logical entity - this can be achieved by the use of a Document set (called Student file as example) that will include all the other elements stated above. You just need to find a way to send your SSRS reports to the appropriate Document Set (within a library) and this can be done with some coding
- Second, the Records Management side of this. A document set can be declared as a Record and every element within the Document Set will be declared as a Record. SharePoint will treat the whole content of the Document set as a "unit", which greatly ease the management of the elements
Hope this helps,
Alain Lord - MVP SharePoint Server