Problem with IBM TRIRIGA OOB Security Group Report

I encountered an issue with the out of the box report and IBM has confirmed that it is a defect and has provided me with a workaround. It seems to only happen if TRIRIGA is using SQL as the database. 

This should be done with someone that is a BIRT Report Developer. Once the report has been updated, take the updated .zip file and check out the older report and check in the new one in Document Manager.

Here is the workaround. 

1 - In the report designer, expand the Data Sets section to reveal the SecurityGroups and SecurityPermissions datasets.

2 - Expand the SecurityGroups dataset to reveal the NAME1 object.

3 - Click on the Advanced vertical tab in the Property Editor.

4 - Scroll down to find the Query property. It will look as if the Value is set to SELECT name1.

5 - Click on the Value and you should see this SQL:

SELECT name1

FROM t_group

WHERE name1 <> 'Admin Group'

6 - Everything except 'Admin Group' should be in uppercase in order for SQL to process the query correctly.