team-moeller / better-access-pivottable Goto Github PK

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

Add a property to specify if the pivot table is interactive

Add a property "ShowInBrowser".
This should, when is set to true, start the internet explorer / edge and show the generated pivot table.

Add a property to control the row order

Add a property named "DisplayIn". This property will control, where the output for the chart is generated.
Possible values:

• chWebBrowserControl (default today, renders the chart in the webbrowser Control)
• chSystemBrowser (renders the chart in the systems webbrowser, already possible today)
• chWebBrowserActiveX (for further use, renders the chart in a webbrowser activex control)
• chImageControl (for further use, renders the chart and displays it in a n image control)

Add properties where one can specify the source of scripts and css:

• jquery
• jquery-ui
• pivot.js
• pivot.css

Should be possible via locale file or CDN

On this way we will be able to print an image of the pivot table in a report.

• table
• query
• sql-statement
• recordset (ado and dao)
• demo (?)

Release a first initial version with static values to check if the concept is working

Add a property to specify the name of the rows for the pivot table

There is a bug when you call "ImportModules" all imported modules have a suffix "1" in the name.

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.

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.

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.

In the generated HTML file are two comments fot the MOTW.
Only one is necessary.

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 method to export and import modules as textfiles
These files can be uploaded to github

add a page with information how to contribute to this project to the wiki

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.

Outsource the code for generating the html string to a separate class

Add a property where you can specify the name of the renderer

• Table, Heatmap, ...

Add a property to control the column order

Add a property to specify the name of the columns for the pivot table

Make font type and -properties configurable.
Styling seems to be possible via css.

The row totals are always shown.
The visibility should be controlled by a property.

The coding interface seems to be clearer when we change the property ShowInBrowser to be a method.

Add a property to specify the name of the data source object (table or query)

Add a comment with license information's to the modules
The version number should also be in this comment

Adapt newly added code to standards in the project

Insert table with demo data as a basis for simple data binding

Add a form to the database where the user can set the values for the generated demo

The styles section is currently located between head and body.
The styles section should be moved to the head section.

Replace the table with demo data. The content is in German. A table with content in English seems to be more appropriate.

Correct forms labelling:

• frm_Configuration
• frm_Startup

By default the UI is English.
Make localization available.

The column totals are always shown.
The visibility should be controlled by a property.

The margin is fixed 30px.
It should be possible to control this value via a property

Add some content to readme.md
Explain the project: why and how

Add StringBuilder Class to make code more readable

Add a property where you can specify the fields that contain the values for the function

implement simple data binding:

• load data from a chosen table

Revise the script references.

• Only use needed references
• Look for CDNs as a source

Add a property where you can control the name of the function which is applied to the data

• Count, Sum, Average, ...

rename the generated html file
index.html => BetterAccessPivotTable.html

add basic content to the wiki:

• Homepage
• Prerequisites
• Limitations

• Fix bug when importing modules
• Add Method "ExportModules"

Make the html file more readable.
Therefore, outsource the data in its on block

Revise the html file

• reorder blocks in the file to make it more readable