Begin by creating a procedure that contains a graph.
Later, you will add this graph to a frame in the HTML file and drill
down to it from a report that you will soon create.
Procedure: How to Create the Graph
the Procedures folder under the Century project.
then select Procedure from the context menu.
The Add Procedure dialog box opens.
Type STORSAL in
the File name text box and verify that Procedure Files (*.fex) is
selected from the Files of type drop-down menu.
the Create with drop-down menu, select Procedure Viewer.
The Procedure viewer window opens.
the diamond to the right of the default Comment component and select Graph from
the component connector toolbar.
the CENTORD Master File and click Ok.
the Format tab and click Other from the Chart
The Other Chart Types window opens.
Select Lines from
the Chart Types group.
InfoAssist refreshes showing a sample absolute line chart.
the Data panel, double-click Line, Total to add
it to Measure (Sum) in the Query panel.
the Data panel, double-click Store, Name to
add it to X-Axis in the Query panel.
Name in the Data panel, then drag the field into the
Multi-graph heading in the Query panel.
Procedure: How to Create a Heading for the Graph
Adding a heading to your graph provides
important information to describe the data you want to display.
You can add headings and footings for your graph by clicking the
Heading & Footing button, located in the Home menu. In this
tutorial, you will add a heading.
the Home tab, if it is not already selected.
the Header & Footer button.
The Header & Footer dialog box opens. Page Header is
selected by default
of and leave a space.
Drag PRODNAME from
the Field list into the Header & Footer dialog box.
<CENTORD.INVSEG.PRODNAME is added to the Heading.
the cursor after <PRODNAME and leave a space.
Your header will look like the following: Sales of <PRODNAME
for Each Store
Click Apply then OK to apply
and close the Heading dialog box.
Procedure: How to Limit Graphed Data
You can limit the data displayed
in a report or graph by adding a filter. Here you will create a
statement that limits the data in the graph to a certain product. You
will enter this criteria as a parameter, and use the parameter later
in the tutorial when you set the drill-down option for the report.
the Data tab.
the Advanced button from the Filter group to
view the Advanced Filter expression builder.
The following image shows
the Advanced Filter expression builder.
Advanced Filter expression builder:
Click OK to
save your filter.