I am looking to combine two seperate web parts and "report" on a different webpart.
Let me explain.
I have two sites within sharepoint. Risk Register, and Change management. Risk Register is a simple maually made populated page with discovered risks through out the environment, and change management is a calendar that is populated with change then appoved and then change takes place.
What I would like to do Is take a particular web part and report on the top most issues on each. So for instance I want to take risk regisiter and display the top 5 high issues on a different portal I am creating, same with change management. Does this make sense? How can this be done? Any suggestions will be helpfull.