fyiReporting Software, LLC
Graph data
To create a chart click on the chart toolbar item and then click into the body of the report. This will bring up the Chart wizard as described below.
Select the DataSet you want to use. The columns in that DataSet will appear in the DataSet Fields list. You'll need to create a new DataSet using the menu Data/DataSets/New... before creating the chart if the datasets available don't provide the information you need.
Select the chart type (Area, Bar, Column, Doughnut, Line, or Pie). Depending on the type you choose there may be multiple subtypes available for choice. For example, if you choose Column you'll have a choice of Plain, Stacked (all series will show in single bar), or PercentStacked (all series data will show in a single bar totaling 1 with each series showing in the bar as a percentage).
Pick the fields for the Categories by clicking on a DataSet Field and hitting the > button next to the Categories list. Categories frequently show as the X axis or the horizontal axis.
Pick the fields for the Series by clicking on a DataSet Field and hitting the > button next to the Series list. Series frequently show as the Y axis or the vertical axis.
Pick the Chart Cell Expression by choosing from the drop down list box or by editting. The drop down list box is populated with Sum expressions for each field in the DataSet that hasn't been picked for a Category or Series.. However, you can edit the expression after picking one. For example, you might want to change "=Sum(Fields!Region.Value)" to "=Count(Fields!Region.Value)".