Binding Query with Report Controls

After adding queries to the data source instance, a list of all queries and their columns can be viewed by expanding the Data Source instance. To bind a Query with Report Controls:

1. Click Field List.

2. Within the Field Sources menu, drill down and locate the desired query.

Field list showing various attributes like FOLDER_ID, FOLDER_OWNER, and SUBJECT.

3. Click and drag the query into the applicable report Detail1 area.

Document layout showing various sections and highlighted compliance elements for review.

4. Add labels to the columns, report headers, and footers by dragging items from the Controls bar into the workspace.

Report designer interface displaying user data fields and layout options for customization.

5. Link the report to the SQL command created above to populate the report with the data stored in the data base. In the Properties menu with the report field selected, fill in both the Data Source and Data Member fields under Actions. It should match the information created in the Field List section.

Settings panel displaying data source, member, filter string, and measurement units options.

6. Click Preview within the toolbar to preview and export report data.

Sample users report displaying email, names, and user IDs in a table format.

7. If the design is suitable, save the report by clicking Save. After saving, the report is available to eCASE users. Alternatively, click the Designer option to continue editing the report.