report-data should be automatically written to a word document

  • 24 March 2022
  • 2 replies



I want to automatically write data from reports into a Word document. For example, the number of failed jobs from the backup-job-summary report should be written to a Word document. Is there already a workflow for this or does anyone have an idea how to implement it?


Best answer by Mike Struening RETIRED 24 March 2022, 18:50

View original

If you have a question or comment, please create a topic

2 replies

Userlevel 5
Badge +16

I doubt such a thing exists as its such a specific use case. My guess would be that your best best is to not use workflows for this but rather some unholy combination or Powershell and the reporting server.


You could some something like authenticating to the report engine using the rest api, pull the report data into a powershell object and write its contents to a word document.

This guy shows how to write word documents from powershell

This doesn’t look that hard to be honest, but its’ not trivial. 

I would imagine that in addition to having to create this word document it needs to be delivered somewhere so there are a whole bunch of things to consider.

Userlevel 7
Badge +23

@christopherlecky is correct; I’m not aware of anything that specific.

What you can do is schedule reports to run and save to a network share.  I don’t believe Word .doc is a listed extension/file type, though html and pdf are.

ps Welcome @lrehan !