team-moeller / better-access-pivottable Goto Github PK
View Code? Open in Web Editor NEWBetter pivottable for Access with pivottable.js
License: MIT License
Better pivottable for Access with pivottable.js
License: MIT License
Add a property where you can specify the name of the renderer
Adapt newly added code to standards in the project
In the generated HTML file are two comments fot the MOTW.
Only one is necessary.
The coding interface seems to be clearer when we change the property ShowInBrowser to be a method.
When a method "PrepareAndExportModules" is called, the version number is updated in all modules before export.
This is helpful for the power user. For the contributor, the update of the version number is not needed and, in some cases, inconvenient.
We should have a "ExportModules" function for the contributors.
Add properties where one can specify the source of scripts and css:
Should be possible via locale file or CDN
Add a control to the config form where the user can specify this property.
Then use this property when the pivot table is created on the demo form
Release a first initial version with static values to check if the concept is working
Add a property to control the row order
Outsource the code for generating the html string to a separate class
Correct forms labelling:
Make the html file more readable.
Therefore, outsource the data in its on block
On this way we will be able to print an image of the pivot table in a report.
Replace the table with demo data. The content is in German. A table with content in English seems to be more appropriate.
The whole html-string is saved in a file which is loaded into the webbrowser control.
Make this file superfluous and load the html-string directly into the webbrowser control.
Add a form to the database where the user can set the values for the generated demo
Add a property to specify the name of the rows for the pivot table
Add a property to control the column order
Add a property to specify if the pivot table is interactive
Make font type and -properties configurable.
Styling seems to be possible via css.
Make it possible to show the pivot table in a webbrowser activeX control.
This feature expands the possibilities of Better Access PivotTable and ensures alignment with the sister project Better Access Charts
Add a property where you can control the name of the function which is applied to the data
Adjust the name for the generated html file
Current: BetterAccessChart_{WebBrowserControlName}.html
Future: BetterAccessPivotTable_{WebBrowserControlName}.html
Actually, there is an error if a field name contains a blank or a special character like "-" or "/".
Fix this.
rename the generated html file
index.html => BetterAccessPivotTable.html
Add a property where you can specify the fields that contain the values for the function
By default the UI is English.
Make localization available.
The row totals are always shown.
The visibility should be controlled by a property.
add a page with information how to contribute to this project to the wiki
There is a bug when you call "ImportModules" all imported modules have a suffix "1" in the name.
Insert table with demo data as a basis for simple data binding
The styles section is currently located between head and body.
The styles section should be moved to the head section.
Add a property named "DisplayIn". This property will control, where the output for the chart is generated.
Possible values:
Add a property "ShowInBrowser".
This should, when is set to true, start the internet explorer / edge and show the generated pivot table.
Add some content to readme.md
Explain the project: why and how
The column totals are always shown.
The visibility should be controlled by a property.
implement simple data binding:
Add a comment with license information's to the modules
The version number should also be in this comment
Add a method to export and import modules as textfiles
These files can be uploaded to github
The margin is fixed 30px.
It should be possible to control this value via a property
add basic content to the wiki:
Add a property to specify the name of the columns for the pivot table
Optimize the transfer of the parameters for cols and rows.
It should be possible to leave out the embracing single quotes around the field names.
These could be added internally.
Revise the html file
Add a property to specify the name of the data source object (table or query)
Add StringBuilder Class to make code more readable
Revise the script references.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.