 
Full list of options introduced by Active XL Report Pro
Active XL Report Pro supports all the features of Active XL Report (Standard). What follow below is the full list of options and parameters added by Active XL Report Pro:
CHART |
 |
Refreshes a given chart with list range data.
|
SUM, AVG, AVERAGE, COUNT, COUNTNUMS, MAX, MIN, PRODUCT, STDEV, STDEVP, VAR, VARP |
Now you can get totals in arbitrary ranges through the use of the \TOTALOFROW parameter.
|
GROUP (with subtotals) |
Available parameters: ASC, DESC, COLLAPSE, MERGELABELS, MERGELABELS2, PLACETOCOLUMN, DISABLEOUTLINE.
|
GROUP (without subtotals) |
Available parameters: ASC, DESC, COLLAPSE, MERGELABELS, MERGELABELS2, PLACETOCOLUMN, WITHHEADER, DISABLEOUTLINE, DISABLESUBTOTALS, PAGEBREAKS.
|
SUMMARYABOVE, SUMMARYBELOW |
Range options. Allow placing the summary row below or above the group header (if any).
|
GROUPWITHHEADER |
Allows using all features available for usual cells straight in the group header.
|
DELETECOLUMN |
Deletes a column of a range.
|
OUTLINE |
Allows creating the Outline view for nested ranges.
|
How to get more details
|