Is it possible to create PDF documents (e.g. on a nightly schedule) with Tableau and have those documents exposed by a URL by the Tableau server?
This sort of approach is common in the Jasper Reports and BIRT world, so I was wondering if the same approach is possible with Tableau?
I couldn't see any documentation on the Tableau site for creating PDFs, other than print to PDF
Print to PDF. Note: If you're using Tableau Online or Tableau Server, instead see Download Views and Workbooks and Link to a PNG, PDF, or CSV of a View. In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
To publish to PDF: Select File > Print to PDF. In the Print to PDF dialog box, select the print range: Entire Workbook - publishes all the sheets in the workbook. Active Sheet - publishes only the sheet currently displayed in the workbook.
Export data in the view to Microsoft Access or . In Tableau Desktop, select Worksheet > Export > Data. Select a location and type a name for your Access database or . csv file. Click Save.
With the new PDF attachment to subscription, users can easily create a report bursting workflow in Tableau by combining PDF attachment in subscriptions and User Filters in workbooks.
With Tableau Server, you can access your published workbook in a pdf format with this URL:
http://nameofyourtableauserver/views/NameOfYourWorkbook/NameOfYourView.pdf
Simply, the url is the url of your view + you add ".pdf".
The pdf file will be generated dynamically when accessing the URL.
Another option is to program your own script with tabcmd. You can have more info on tabcmd here: http://kb.tableausoftware.com/articles/knowledgebase/using-tabcmd
The same technique also works for PNG. You can control filters using ?field_name=value. You can even select multiple values like this ?field_name=value1,value2.
Parameters can be set the same way.
Personally I've had the best luck with discrete dimensions instead of continuous ones.
I use the Windows Task Scheduler with batch files and Tabcmd.
Programs needed:
http://onlinehelp.tableausoftware.com/v8.1/server/en-us/tabcmd_overview.htm (tabcmd, how it works?)
Batchfile (create a text file and then save with file extension .bat):
Windows Task Scheduler:
You can do this by typing
http://server/views/WorkbookName/SheetName.pdf?:format=pdf
Another option will be using javascript api like below..
function exportPDF() {
viz.showExportPDFDialog();
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With