Graph Example

Graphs provide an easy way for the reader to get an overview of the data trend.

1. Select the Detail1 section, the Options Menu will open on the right. Under Actions, select the Insert Group Header Band.

Grid layout showing margins and sections for document formatting and organization.

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 the Binding Query with Report Controls section to bind the query with the data.

NOTE: You must bind the report (step 5 from 4 the Binding Query with Report Controls section ) to the Data Source and Data Member before you can complete step 4.

SQL query interface for selecting folder status and counting records from a database.

3. Drag a Chart control into the GroupHeader1 section and expand the chart to the max width of the Report Designer Workspace

Message indicating no visible series to represent in a chart, suggesting adding new series.

4. Click Run Designer

5. Add the required information to the Chart Designer under Properties to create a Bar Chart:

Bar chart displaying data series with numerical values and properties settings on the side.

a. Data Source: eCASE1

b. Data Member: CustomSQLQuery_1 (the Data Member list populates based on the selection for Data Source)

c. Series Data Member: FOLDER_STATUS (this populates the X-axis)

d. View: Bar (this determines the type of chart)

e. Argument Data Member: FOLDER_STATUS

f. Value: number_of_f

6. Add a title to the chart by clicking Add next to Titles under the Chart Structure. Add the desired properties to the title.

Chart displaying the number of folders categorized by their status with data labels.

a. Text: Number of Folders by Folder Status

7. Select OK when you have finished configuring the Chart Settings.

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

Bar chart showing the number of folders by their status, highlighting open folders.