Hi

The combination of WpDataTables plus Gravity Forms Integration and Report builder is working well for us.  It is enabling us to have users input data via Gravity forms, store and display that in tables and then download a formatted xlsx based on a template that has lots of formatting.

We now would like to create more complex reports/tables with interrelated logic. That logic would include things like ( If cell (row 1, column  A) of table 1 ="XXX" then value in  cell (row 10, Column B) ="YYY".  Also some function similar to VLookup.  

We can see that WPDataTAbles is a long way from being able to work with logical statements in its tables. ( that would be a great future addition!)

Therefore, we are looking for a work around where we build the logic into the xlsx template and then have it populated by Report builder. We'd like the option to produce a pdf of the xlsx as if the xlsx file had been printed using the page setup/print stettings as per the xlsx template.  

Ideally we'd like the font end users to generate the report and then be able to view it on screen with an option to  download as a pdf rather than just xlsx. This way we could build sophisticated logic within the template as part of our intellectual property but protect it by only providing users view access and or download of pdfs.

Do you have any plans in this area? or Do you know of a way we could create pdfs of the xlsx docs that Report builder creates for view/ and download?

Longer term, are you thinking of adding any  logic type functions(IF/THEN?ELSE) or  Vlookup type functions within and between WPDataTAbles?

Thanks

Chris