Okay
  Public Ticket #1333789
Report Builder - adding totals to Excel files
Closed

Comments

  •  6
    lolapopp started the conversation

    Hi,

    I have a question about Report Builder. Am I correct assuming that it allows me to set the table in a way that all totals I have in my table will be visable in downloaded excel file? The description says that it is possible for "certain values" so I'm not sure if it means the same values for which calculating total in table is possible. Also I want to know if this option is avaiable in front end? I mean user clicks "Excel" button above the table and what he gets is a file with a total numbers? I have dynamic data in tables and I'm not sure if this will work for me.

    Best regards,

    Jola

  • [deleted] replied

    Hi Jola,

    If you are generating a single report for all rows, you can calculate totals for numeric (float and integer) columns, to do this insert the variables like:

    ${mycolumn.total}

    This means that you can enter this variable on the desirable place in your template and it will be replaced by actual calculated number.
    Best way to show totals in the frontend is with the table where you can show it in column footer and somewhere else on the page with the shortcode. 

    Report builder is separate functionality from table export with table tools. Please see this documentation on how to create Excel reports with Report builder.

    You can see and try all the features from this addon in our sandbox website:
    http://sandbox.wpdatatables.com/
    username: demo
    password: demo

  •  6
    lolapopp replied

    Hi,

    Thank you for your help. I have the addon and it is really good.

    Best regards,

    Jola