I have a page where search result is displayed after entering a few criteria such as start date, end date and account ID. The query is done via middleware SQL and the search result is populated into a Grouptable using a non-persistent entity.
Now I have no problem exporting the result as Excel using <action id="excel" type="excel"/>
, however there is no built-in functionality to do the same for PDF.
From what I’ve gathered, I will need the reporting add-on to export PDF files. However, it seems like the report generator requires a persistent entity if I were to use its wizard to create report. I also notice there’s SQL query in the Report documentation but how do I make use of my query which already run during the search itself?