|Please consider donating $1 per sample downloaded, (find out why here)|
Joined: 30 Jun 2008
Posted: 17 Apr 2012 at 12:45am
This sample db demonstrates a simulated pivot table, displayed on access subform in datasheet view. It is based purely upon native access queries and VBA, getting rid of traditional dependence upon OWC i.e. Office Web Components (slated for deprecation).
2 - Incorporation of features typical of excel pivot table:
2.1 - Being a datasheet, column headings remain in perpetual view, affording convenient vertical scrolling.
2.2 - Suitable number of grouping columns at left are frozen so as to facilitate convenient horizontal scrolling.
2.3 - Uncluttered display (suppressing duplicate contents in grouping columns).
2.4 - Full choice of filter fields (equivalent to page fields in excel)
2.5 - Appropriate cross tab columns if a field is selected as column field. (Only one field can be selected as column field)
2.6 - Toggling of data orientation between column and row styles as per user choice.
2.7 - Manipulation of ordinal position of columns - as desired by user - by clicking up or down command buttons in field list.
2.8 - Run time insertion of unlimited number of calculated field columns - as desired by user. Calculated field names and the underlying expressions can be edited as and when desired. The results of any such action get displayed promptly in the pivot table.
2.9 - Run time setting / editing of formatting for different data fields - as desired by user. The results of any such action get displayed promptly in the pivot table.
2.10 - Run time hiding / un-hiding of grouping and data fields as desired by user (By clicking Hide check box in fields list).
2.11 - Fields List and Filter Check-List can be hidden un-hidden via command button. The filter list gets displayed only if IsFilter check box against one or more fields is in selected state.
2.12 - If desired by the user, filter field columns get displayed in the pivot table as well.
2.13 - Cell-wise graded collapse / expand action in the pivot table can be performed by double clicking on a column PRIOR to the last one amongst grouping columns.
Note (see item 2.5 above):
3 - Some Interesting Extra Enhancements:
3.1 - Generic Data Source:
3.2 - Column-wise auto-expand and auto-collapse:
Step by step sequential auto-expand or auto-collapse of pivot table, column-wise, can be carried out by clicking pertinent command button. (Non-sequential random hiding / un-hiding of pivot table columns can be carried out by clicking Hide check box in fields list).
Note: Cell-wise graded collapse or expansion can be done by double click (See item 2.13 above).
3.3 - Flexible Run Time Grouping By Date Type Fields:
3.4 - Color Highlights For Pivot Table Rows Depicting Sub-totals:
3.5 - Color Highlights In Fields And Filter List:
3.6 - Reminder Content In Outer Columns:
Version: Access 2000 file format.
Download File >>: uploads/37/Form_PivotTableSimulated.zip
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum