Report Definition form
|
Complete these tabs in order from left to right to define an interactive chart. After you complete all tabs, click OK to save your inputs.GATZH 3/31/2010
Select a type for the chart in the left panel. The right panel shows subtypes of the selected type.
Selection |
Description |
Type |
Select a type. For examples, review the small images or these definitions: area chart, bar chart, column chart, line chart, and pie chart. |
Subtype |
Select a subtype for the selected type. For bars and column charts the subtypes are:GATZH 3/30/2010
For area charts, the subtypes are:
For a pie chart, the subtypes are:
For a line chart, the subtypes are:
|
Complete the Data tab to indicate which summarized column to display in the chart and which group by column values to display along the sides of the chart.
A summarized column contains data that is summarized using one of the following built-in functions: COUNT()
, SUM()
, AVG()
, MIN()
, and MAX()
Examples include: counts of class instances (or record counts), total dollar amounts, average elapsed time between the entering and resolution of a work item, the most recent (maximum) date value, the earliest (minimum) date value.
All non-summarized columns on the report are considered group by columns, since the summarized data is grouped by, or broken out by, these other columns.
Bar, Column, Area, and Line charts arrange their chart elements within a rectangular grid in which, by default, summarized column values are indicated by the values along one axis (or side) of the chart (also known as the summarized column axis), and group by column values are displayed along another axis (or side) of the chart (also known as the group by column axis).
Chart Type |
|
Bar |
|
Column |
|
Area |
|
Line |
|
Field |
Description |
Group by Columns |
For pie charts, select a single group by column. For bar, column, area, and line charts, select one or two group by columns whose values provide the names of the wedges in ToolTips and legends. The selections use the column headings defined for these columns on the Design tab.GATZH 3/30/2010 |
Summarized Columns |
Select a single summarized column. The selections use the column headings defined for these columns on the Design tab. |
Rotate Axes |
Optional. For bar, column, area, and line charts, selecting this option rotates the axes for the chart so that the horizontal axis becomes the vertical axis, and vice versa. |
Limit to top |
Optional. Enter a value to reduce the number of graph elements to a
small set that users can more easily interpret. The default is After sorting by largest category first, the system combines elements that rank lower than the limit into a single chart element. For example, if you limit to the top 5 values, the chart contains the top 5 values plus a 6th value representing the sum of all values not in the top 5.GATZH 3/30/2010 |
of |
Optional. For bar, column, area, and line charts, if you chose a numeric limit in the Limit to top field, and you selected more than one group by column to chart, identify which summarized column you want the top n elements of. |
This tab is only available for bar, column, area, and line charts. Complete these fields to control the location and appearance of the axes.
Field |
Description |
Group By Column Axis | |
Show Grid Lines |
Select to include grid lines for the axis. If not selected, only tick marks appear. |
Show Labels |
Select to label points on the axis with values. |
Placement |
For a bar chart, select For column, line, and area charts, select |
Scale |
For line charts. Select For other chart types, only |
Summarized Column Axis | |
Show Grid Lines |
Select to include grid lines for the axis. If not selected, only tick marks appear. |
Show Labels |
Select to label points on the axis. |
Placement |
For column, line, and area charts, select For bar charts, select Bottom or Top as the location of the axis. |
Select options to control other chart elements and to allow users to interact with the chart.
Field |
Description |
Customize Settings | |
Chart Size |
Select |
Show Data Tips |
Select to display data points in ToolTip text. |
Show Maximize Button |
Select to include a maximize button () that allows users of this interactive chart to open the chart in a new window at full screen size. |
Show Data Button |
Select to include a Show Data button () that allows users to view the summary view data in tabular, non-chart format. This button is functional only when the chart is produced by the chart JSP tag. |
Open in New Window |
If the Show Data Button box is selected, the summary view data will open in a new window rather than in the current window. |
Maximum Column/Bar Width |
For column and bar charts only. Choose a value between |
Series Effect |
Use an effect to allow users to interact with the chart.
This is most useful for line charts with a
Effects are not available for the |
Line Weight in Pixels |
For line charts. Select to control the width of lines in pixels. |
Drop Shadow Filter |
For line charts. Select to apply a drop shadow to lines. |
Legend | |
Show Legend |
Select to present a legend identifying chart categories and colors for each category. If not selected, other fields in this area of the tab are ignored. |
Direction |
Select |
Placement |
Select |
Slider | |
Show Slider |
For bar, column, area, and line charts only. Select to present a slider control. If not selected, other fields in this area of the tab are ignored. Not used with pie charts. |
Title |
Optional. Enter title text to appear to the left of the slider, identifying the function or units of the slider. |
Size |
Optional. Enter a width in pixels for the slider. |
Group Count |
Optional. Enter a maximum number of group elements to present initially. The user can move the slider to see more or fewer elements. |
Label | |
Show Label |
Pie charts only. Select to show labels that display information about each data point. If not selected, other fields in this area of the tab are ignored. |
Include Percent |
Pie charts only. Select to include the size of the wedge relative to the pie in the label. |
Complete these optional fields to label the chart and axes.
Field |
Description |
Chart | |
Title |
Enter a word or a phrase for the chart title. |
Font Style |
Select a font style for the title text. Options include: Regular, Italic, Bold, Bold Italic.GATZH 3/30/2010 |
Font Size |
Select the font size for the title text.GATZH 3/30/2010 |
Axes | |
Group By Column Axis |
Enter a word or phrase for the title of the group by column axis. |
Summarized Column Axis |
Enter a word or phrase for the title of the summarized column axis. |
Font Style |
Select a font style for the axis titles. Options include: |
Font Size |
Select a font size for the axis titles. |
Working with the Report Viewer
Manager portal — Using the Report Browser |