Chart Definition
Here you specify all the parameters for your chart. The Chart Definition screen allows you to define the parameters for your finished chart. Press the Reset button if you want to undo all your selections and changes.
Type:
Chart Type. Select the desired chart type for this chart as the default. Users will be able to change between chart views at run time.
Special Where Clause. If necessary, you may add a special SQL Where clause to control the data returned to the report.
In Maximum result rows, choose the maximum number of rows to be returned in the result list. The default is 1000. This value controls not only the number of rows returned for a search but also the number of rows plotted on a chart. The chart preview will also use this value. BulletProof suggests keeping it low initially until you see how your data looks when charted.
Titles:
Chart Title. Enter the title of the chart which will appear at the top center. JDesignerPro enters the table name by default.
Chart title Color. Choose the title color.
X Axis Title. Enter the tag for the x axis.
X Axis Title Color. Choose the color for the x axis tag.
X Axis Label Color. Choose the label color for the X Axis. The labels represent the data elements used in the chart and appear along the axis in intervals.
Y Axis Label Color. Choose the y axis label color.
Chart frame Color. This is the color for the line frame around the whole chart.
Scaling:
Automatically calculate min and max values. The JDesignerPro charting will scale by itself if you choose Yes here. This means it will make the scale of the chart to fall between the minimum and maximum values, so no plotting will go off the edge of the chart. In cases where there is a large difference between a few values in your data or where there are a few very large or very small values, you may want to turn scaling off. This will allow the chart to show better detail for the majority of the values.
Adjust the minimum y value to zoom in. For line charts, select whether you want the scale to adjust to the lowest plotted point.
Minimum / maximum y value. Enter the minimum and maximum y axis values if you have chosen not to use automatic scaling. If you have chosen Auto scaling, the min and max values will already be displayed in these fields and the fields will not be editable.
Grid Settings. Choose whether you want horizontal and/or vertical lines by choosing Yes or No in the corresponding pull downs. Also select whether to have the grid be in the foreground, on top of the chart, or in the background.
Background grid color. Choose the desired color for the grid.
Data grouping:
Single-click one column by which you wish to group the data on the chart. This would typically be a date or department or similar field, but you can use any available column. For a date you may choose to summarize by day, month or year. The SQL to perform the grouping will be generated. You may change it as required.
When you click on a date type field, the Group by pull down will show the matching series choices. For a date field you will see Day, Month and Year selections. Other fields do not have Group by choices in this pull down.
Multiple series:
Choose the column for creating multiple chart points or bars. This is used to perform grouping by some code such as state or product ID. In this case a sales chart would be grouped by Sales person, then the series would be each Product Id which that sales person sold in a month. If a sales person sells four products, there will be four bars on the chart above that persons name on the chart. You may adjust the SQL as necessary
Chart detail:
Include column in chart. Choose Yes for column(s) that contain the numeric data to be plotted. If you have selected a multiple series or chosen a pie chart only the first selected column will be plotted. By default all of the columns are selected. You should deselect the columns that are not required.
Aggregate Function. If you have chosen a column in the Data grouping sub-tab you must specify an aggregate function, otherwise you may plot the actual data points. The choices are Sum or Average of the data elements.
Legend Text. Enter the legend text for this column. This is not applicable to multiple series or pie charts.
Element and Element Border color. Enter the element and border colors for this column. This is not applicable to multiple series or pie charts.
If necessary, you may modify the SQL clause for this column to do such things as derived values.
Once you have setup all your result parameters, press Accept to preview the chart.