Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #3527132
How to show "Info block" in PDF
Closed

Comments

  • Daniel Ochoa started the conversation

    Hi Support team,

    I'm having a problem with showing the "Info block" in PDFs. The "Info block" is used to show the number of rows in a data set. When I filter the data, the "Info block" still works correctly. However, I need the number of rows to also be displayed in the PDF.

    Can you please help me with this?

    Thanks, Daniel Ochoa

  •  1,689
    Miloš replied

    Hi Daniel,

    Regarding the export question :

    The table tools functionalities are based on a 3rd party HTML5 library and they are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.

    There are some limitations in this library we will emphasize for your awareness:

    • For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export:6992668217.png
    • Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed (but the title can – see below).
    • Conditional formatting is not reflected in any of generated export files.
    • Other front-end extensions cannot be combined with Table Tools. If you have row grouping enabled for the table, or there are some customizations you did yourself, they won’t be reflected in the generated Excel, CSV or PDF document, nor in the clipboard.
    • When you export tables with the wpDataTables plugin, please note that you can export values, but not formulas. WpDataTables doesn’t support exporting formulas, so a Formula column will be exported only with values; and any calculations of Average, MIN, MAX, and Total will not be exported at all.
    • Exporting images is not possible at the moment, but you are able to export them as HTML with the new “Include HTML” option.
    • You can’t export columns that are hidden – they will not be visible in any exporting or printing tool.
    • Export numbers with comma as decimal separators have issues in the Excel report. Please use the CSV export button or change column type to string for these columns.

    -

    If you wish to try better PDF export options right now, our advice would be to acquire something similar to the WP Advanced PDF plugin, which offers a lot more options when creating PDF files from our tables, along with other content on your website.

    -


    If you wish to make a development suggestion to add what you need in the future as built-in option,

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -


    I also tried to think of any possible workarounds how you might pull that number in a different way;

    For example if you add a Formula Column and have it just set to "1" - then it can serve as a "Count of rows";

    Then you can add a SUM calculation to this Field to serve as the total number of rows, which also follows Table filtering;

    but unfortunately, we can not currently export any Calculation function of the Table either, in our Export Tools or with our Add-on Report Builder as well, so we don't have a valid solution at the moment or a workaround.

    But our devs will do their best to add some solution as soon as possible.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables