Hi, I have created a SQL View in PHPmyAdmin (SQL for Table 1.png), giving me results in (SQL Results Table1.png)
I then used the view to create a SQL table in WPDateTables (WPDataTables SQL Table1.png), with results in (WPDataTables Table 1.png)
You will note that for some reason the the values in the Total Column is formatted using the (,) as the decimal point. ie. Accounting fees of 6,600.00, becomes 6.00 and Electricity and Water of 112,791.08 becomes 112.00 etc.
It appears that the Formatting of numerical fields based on a calculated SQL, is wrongly formatted, using the (,) delimiter as the decimal point and zero rounding .
I have replicated this with other tables with the same results. I have also run the SQL Query in another plugin (EZ SQL Reports) and the SQL gives the correct result (EZ SQL Report.png)
Another Question: Why does WPDataTables fail when it tries to render Queries that contains JOINS. It is really a pain having to create views in PHPmyadmin and then reference them in WPDataTables.
Another Question: With WPDataReports, is it possible to create a WORD report that also outputs in a Wordpress Page.
Can you please change the number format in wpDataTables main settings to match the format in your source
and let us know if you still have the same issue.
With wpReportBuilder you can generate reports using Word templates, please have a look at our documentation for more detailed information and examples of the available features
Yes I did try both formatting methods. It made no difference
Regarding the Report Builder. I have gone through the documentation. What I can't see is displaying the report that I have generated as a Word template as a POST in WordPress.
Example. wpDataTables set up to produce an invoice in Word. On Submit, it would then produce the Word Invoice and mail to client. I then want to also display the formatted invoice in a post format on WordPress
Can you please provide me a temporary WP-admin (administrator) user for your site where this happens and the table ID, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
Hi, I have created a SQL View in PHPmyAdmin (SQL for Table 1.png), giving me results in (SQL Results Table1.png)
I then used the view to create a SQL table in WPDateTables (WPDataTables SQL Table1.png), with results in (WPDataTables Table 1.png)
You will note that for some reason the the values in the Total Column is formatted using the (,) as the decimal point. ie. Accounting fees of 6,600.00, becomes 6.00 and Electricity and Water of 112,791.08 becomes 112.00 etc.
It appears that the Formatting of numerical fields based on a calculated SQL, is wrongly formatted, using the (,) delimiter as the decimal point and zero rounding .
I have replicated this with other tables with the same results. I have also run the SQL Query in another plugin (EZ SQL Reports) and the SQL gives the correct result (EZ SQL Report.png)
Another Question: Why does WPDataTables fail when it tries to render Queries that contains JOINS. It is really a pain having to create views in PHPmyadmin and then reference them in WPDataTables.
Another Question: With WPDataReports, is it possible to create a WORD report that also outputs in a Wordpress Page.
Hi Rocky
Thank you for reaching out to us.
Can you please change the number format in wpDataTables main settings to match the format in your source
and let us know if you still have the same issue.
With wpReportBuilder you can generate reports using Word templates, please have a look at our documentation for more detailed information and examples of the available features
https://wpreportbuilder.com/documentation/
Hi Blaženka
Thank you for your reply.
Yes I did try both formatting methods. It made no difference
Regarding the Report Builder. I have gone through the documentation. What I can't see is displaying the report that I have generated as a Word template as a POST in WordPress.
Example. wpDataTables set up to produce an invoice in Word. On Submit, it would then produce the Word Invoice and mail to client. I then want to also display the formatted invoice in a post format on WordPress
Regards
Rocky Swartz
Hi Rocky
Can you please provide me a temporary WP-admin (administrator) user for your site where this happens and the table ID, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Filtering, sorting, and search may not work properly if you include:
Unfortunately it is not possible to use Report Builder in the way you described below.