Is there I was I can export a SQL query as a report file? I have the SQL query part all handled, just looking for a way to export it as a report file.
Have you considered using SQL Server Reporting Services?
There isn't a workflow action that will turn the query results into a report directly, but you could take the data and use Word Automation steps, or the Update Document action that adds data to content controls within a Word template. Then you can convert that to a PDF.
Or you can use this post How to build responsive HTML5 report with barcode from list item using Nintex Forms and Workflows and after retrieving SQL data build your HTML report.
Hi Garrett Martin,
What i have done before is to write the data to a SQL DB and from there use a job to generate a report which in turn is saved on SharePoint and like Fernando Hunth mentioned use Reporting Services to display the report (or create a PDF/HTML).
You can use the SSRS web service to export as PDF
Retrieving data ...