Skip to main content
Solved

report-data should be automatically written to a word document


Forum|alt.badge.img

Übersetzen

Hello,
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

@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 !

View original
Did this answer your question?
If you have a question or comment, please create a topic

2 replies

christopherlecky
Byte
Forum|alt.badge.img+17

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.


Mike Struening
Vaulter
Forum|alt.badge.img+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 !


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings