I'm a ASP.NET developer, and I've never done any SharePoint config or development before, but I've been asked to build a report, and I could do with some advice...
The report is based on a list of issues. An issue has a title, description etc, and up to five action plans, each of which has an owner and a target date (so there are five columns for action plan owner 1-5, and five columns for action plan target date 1-5).
There are two requirements for the report:
- it should show issues where the current user owns one of the action plans
- issues should be ordered by the dates of the action plans that belong to the user
I've created a view on the list, with a filter showing only items where action plan owner 1 is [Me], or action plan owner 2 is [Me], etc. This works OK, and satisfies the first requirement.
The second requirement seems to be a bit more tricky. From what I can see, the sorting options for a view seem pretty basic - what I really need is to sort by a formula, but the only option seems to be sorting by col a, then col b, etc.
Is it possible to configure more complicated sorting in a view? If it's not, then what are the other options for displaying this kind of data in SharePoint?