Microsoft Graph Charts (Class=MSGraph.Chart) are implemented as separate Sub-Reports that employ the SSRS Chart element.
Chart Row Sources are converted to MS-SQL stored procedures. As with Sub-Reports, when Master and Child Field Links are supplied, parameter values are passed from the Master Report.
All Chart types (Bar, Pie, etc.) and sub-types (Clustered, Stacked, etc.) available with SSRS Report Designer are supported.
Three-D effects available with both MSGraph and SSRS are supported.
The Chart properties are defined from equivalent MSGraph Chart properties. MSGraph properties that are set to SSRS defaults are omitted from the XML Chart element.
|
|
|
|
|
Property |
Status |
Remarks |
|
Name |
|
|
|
Palette |
|
Set to Excel |
|
Title |
|
|
|
Chart type |
|
All types are supported. |
|
Chart sub-type |
|
All sub-types are supported. |
|
Chart Area Style |
|
|
|
Plot Area Style |
|
|
|
Property |
Status |
Remarks |
|
Dataset name |
|
|
|
Values Section |
||
|
Values Tab |
|
An entry is made for each query "value" field. Query "value" fields contain the data to be graphed. |
|
Series Label |
|
The Access query field name/alias. |
|
Value |
|
The associated field reference (ex. Fields!SumOfSales.Value) |
|
Appearance Tab |
|
|
|
Show Markers |
|
|
|
Marker Size |
|
|
|
Marker Type |
|
|
|
Series Style |
|
|
|
Point Labels Tab |
|
|
|
Show Point Labels |
|
|
|
Data label |
|
Only the value field is currently supported. Developers can display Category labels, Percentages, etc, by substituting expressions in the Value property. |
|
Format Code |
|
|
|
Position |
|
Only Auto is supported. |
|
Label Style |
|
|
|
Action Tab |
|
|
|
Data Output Tab |
|
|
|
Category Section |
||
|
General Tab |
|
|
|
Name |
|
Chart grouping name |
|
Group On |
|
Reference to the query's Category grouping field. |
|
Label |
|
|
|
Parent Group |
|
Not defined by MSGraph Chart |
|
Filters Tab |
|
|
|
Sorting Tab |
|
|
|
Sort On |
|
|
|
Direction |
|
|
|
Data Output |
|
Not defined by MSGraph Chart |
|
Property |
Status |
Remarks |
|
Title |
|
|
|
Show Labels |
|
|
|
Format Code |
|
|
|
Major gridlines |
|
|
|
-- Interval |
|
|
|
Minor gridlines |
|
|
|
-- Interval |
|
|
|
Title alignment |
|
Center only |
|
Scale Minimum |
|
Only supported for the Value Axis.
|
|
Scale Maximum |
|
Only supported for the Value Axis.
|
|
Cross At |
|
Only supported for the Value Axis. |
|
Major Tickmark |
|
|
|
Minor Tickmark |
|
|
|
Side margins |
|
|
|
Reversed |
|
|
|
Interlaced strips |
|
|
|
Logarithmic scale |
|
Only supported for the Value Axis. |
|
Numeric or time-scale values |
|
|
|
Property |
Status |
Remarks |