Now that we have the SQL, let us create a new report that displays our fields in different ways.  This report (see Figure 2) takes the data from our View and groups it by Portal and then by tab.  The detail displays the Permission group name, and the role name, along with the User's first and last name. Feel free to add other fields by modifying the view and then verifying the data source.

Figure 2