Organizing the document can eliminate repeated attributes. For example, you can organize folders and their details (folder ID, folder owner, and the due date) based on the folder status.
1. Select the Detail1 section, the Options Menu will open on the right. Under Actions, select the Insert Group Header Band.
2. Click the Fields List tab. Create a query using steps from section 3.4 or type a SQL command in the SQL string section. Then follow steps from 4.8 to bind the query with the data.
NOTE: You must bind the report (step 5 from 4.8) to the Data Source and Data Member before you can complete step 4.
3. Drag “FOLDER_ID” and “FOLDER_OWNER” into the DETAIL1 section and shrink the section to closely surround the field. Drag “FOLDER_STATUS” into the GroupHeader1 section and shrink the section to closely surround the field.
4. Select the GroupHeader1 section, the Options Menu will open on the right. Click the dropdown menu on Group Fields and select the Add button (+). Select the dropdown menu for the Group By: field and select “FOLDER_STATUS” under the CustomSqlQuery dropdown menu.
5. Click Preview within the toolbar to preview and export report data.
