<!DOCTYPE openRPTDef>
<report>
 <title>User Privileges Report</title>
 <name>UserPrivileges</name>
 <description>Display of User Roles and Privilege assignments</description>
 <grid>
  <snap/>
  <show/>
  <x>0.05</x>
  <y>0.05</y>
 </grid>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource loadFromDb="true">
  <name>role</name>
  <mqlgroup>permissions</mqlgroup>
  <mqlname>role</mqlname>
 </querysource>
 <querysource loadFromDb="true">
  <name>priv</name>
  <mqlgroup>permissions</mqlgroup>
  <mqlname>privileges</mqlname>
 </querysource>
 <rpthead>
  <height>60</height>
  <label>
   <rect>
    <x>195</x>
    <y>5</y>
    <width>540</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>User Privileges</string>
  </label>
 </rpthead>
 <section>
  <name>role_detail</name>
  <group>
   <name>roleuser</name>
   <column>role_username</column>
   <head>
    <height>50</height>
    <field>
     <rect>
      <x>85</x>
      <y>5</y>
      <width>165</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>role</query>
      <column>role_username</column>
     </data>
    </field>
    <label>
     <rect>
      <x>0</x>
      <y>5</y>
      <width>70</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Username:</string>
    </label>
    <line>
     <xstart>5</xstart>
     <ystart>5</ystart>
     <xend>740</xend>
     <yend>5</yend>
     <weight>0</weight>
    </line>
    <label>
     <rect>
      <x>160</x>
      <y>30</y>
      <width>155</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Role Assigned:</string>
    </label>
    <label>
     <rect>
      <x>405</x>
      <y>30</y>
      <width>85</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Description:</string>
    </label>
   </head>
  </group>
  <detail>
   <key>
    <query>role</query>
   </key>
   <height>16</height>
   <field>
    <rect>
     <x>160</x>
     <y>0</y>
     <width>235</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>role</query>
     <column>grp_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>405</x>
     <y>0</y>
     <width>335</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>role</query>
     <column>grp_descrip</column>
    </data>
   </field>
  </detail>
 </section>
 <section>
  <name>priv_detail</name>
  <group>
   <name>priv_user</name>
   <column>priv_username</column>
   <head>
    <height>49</height>
    <label>
     <rect>
      <x>185</x>
      <y>29</y>
      <width>85</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <top/>
     <string>Privilege:</string>
    </label>
    <label>
     <rect>
      <x>95</x>
      <y>29</y>
      <width>85</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <top/>
     <string>Module:</string>
    </label>
    <label>
     <rect>
      <x>0</x>
      <y>4</y>
      <width>70</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Username:</string>
    </label>
    <field>
     <rect>
      <x>85</x>
      <y>4</y>
      <width>300</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>priv</query>
      <column>priv_username</column>
     </data>
    </field>
    <label>
     <rect>
      <x>355</x>
      <y>29</y>
      <width>85</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <top/>
     <string>Description:</string>
    </label>
    <line>
     <xstart>5</xstart>
     <ystart>4</ystart>
     <xend>740</xend>
     <yend>4</yend>
     <weight>0</weight>
    </line>
    <label>
     <rect>
      <x>0</x>
      <y>29</y>
      <width>85</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <top/>
     <string>Role:</string>
    </label>
   </head>
  </group>
  <detail>
   <key>
    <query>priv</query>
   </key>
   <height>15</height>
   <field>
    <rect>
     <x>95</x>
     <y>0</y>
     <width>85</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>priv</query>
     <column>priv_module</column>
    </data>
   </field>
   <field>
    <rect>
     <x>185</x>
     <y>0</y>
     <width>160</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>priv</query>
     <column>priv_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>0</x>
     <y>0</y>
     <width>85</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>priv</query>
     <column>grp_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>355</x>
     <y>0</y>
     <width>385</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>priv</query>
     <column>priv_descrip</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>16</height>
  <label>
   <rect>
    <x>0</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Report Date:</string>
  </label>
  <field>
   <rect>
    <x>705</x>
    <y>0</y>
    <width>40</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>page_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>600</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
  <field>
   <rect>
    <x>105</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
 </pgfoot>
 <rptfoot>
  <height>31</height>
 </rptfoot>
</report>
