Well the major enhancements with this over the previous revisions are:
- Faster - by cleaning up further the codes and looking for ways to speed this up further, this now generates Excel Pivot reports by 20% faster as before
- Added _RepeatLabels property
- Ensured that Excel output will show as Maximized
- Added Arrows to quickly clear previous selections (Filters, Rows, Values and Columns)
- Added option to show or hide Grid Lines on Excel sheet
- There are more which I failed to log before
- Bonus to Subscribers, a sample showing how to use additional automation for this class
Difference vs ssExcelPivot?
- Used native VFP commandbutton
- Used SwitchX for better appearance instead of ssSwitch
- Used OptionSwitchX for better appearance than ssOptionSwitch
- Added Miscellaneous section that allows user to interactively change some properties.
- More options than ssExcelPivot
- Added Show/Hide Grand Total capability
- Added ToolTips on all SwitchX and OptionSwitchX to make things more informative
- Cleaner Popup Form
Briefly, it is designed to allow developer to create any valid pivot report of their choosing from either a table or cursor straight into Excel; even without a single knowledge on Excel automation. As long as you know how to create a cursor, then you are done.
This class allows developer to set a fixed report as can be seen here. Those are the default arrangements and fields I set for that specific report; via codes. However, interactively, any user can still change the pivot report by dragging and dropping fields onto their respective section such as columns, values, rows and filters; before sending those over to excel.
What they cannot do interactively here is word-wrapping which I retain purely via codes for memo fields converted into character type (Excel do not accept a memo field). Word wrapping is done by suffixing the field with colon and the width, e.g., Remarks:30, meaning Field Remarks will be of 30 width inside an excel cell and if content is long, it will be word-wrapped.
Anyway, just check the old ssExcelPivot posts if you are curious as to what others this class can do.