SharePoint Records Management with SSRS Report

Question

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.

Thanks.

---

me

Answer 1

Hi,

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