Example of using the Advanced SQL Conditions on a listing report to give all items that a user owners that has a high risk SLA are shown. This example is based on the Service Request Process App delivered as part of SRC but can be changed according to your requirements.
"ISSUE: If you open the Portfolio view in Project Office eXpress and change the "Organize By" filter to something other than "None", when you try to run the Folder Listing report , no data is returned WORAROUND:
SLA is “violated”. This would then enable all items violating their SLA to be easily identified and manipulated using standard SBM reporting techniques. This can be made more sophisticated if required by adding additional actions at the different SLA risk stages.
