cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export SQL query as report file

Jump to solution

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.

Labels: (2)
Reply
5 Replies
Workflow Hero

Re: Export SQL query as report file

Jump to solution

Have you considered using SQL Server Reporting Services?

Reply
Workflow Hero

Re: Export SQL query as report file

Jump to solution

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.

Reply
Not applicable

Re: Export SQL query as report file

Jump to solution

Hi,

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.

Reply
Not applicable

Re: Export SQL query as report file

Jump to solution

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).

0 Kudos
Reply
Workflow Hero

Re: Export SQL query as report file

Jump to solution

Hi,

You can use the SSRS web service to export as PDF

Thanks,

Pras

0 Kudos
Reply