Transfer Reports to Folder


(Jonathan Lang) #1

I am having a serious brain fart!

How, in Epicor 10, can I run a report and put that report to a folder in Excel for users without manual intervention? I want Epicor to put the report in a shared folder.

Do I have to use something like BI, Doc-Star? Suggestions are very much welcome.

Thank you!!


(Richard Riley) #2

Starting with Epicor 10.1.600, you can specify a Windows Share where a generated SSRS report can be written out. The Share is specified on the Report Style in the Report Options field. The Option has to begin with “File:” (without the quotes) followed by the Share which must be accessible to the AppPool Identity User from the AppServer generating the report. Here is an example for the Report Option value:

File:\EpicorRptShare\Invoices{Date}{ReportID}{Counter}.pdf

As you can see, there are several Substitutions that can be specified (see Style Detail help for the list) and during the report generation - SSRS Database type reports only - the document created will be added to the System Monitor and also written out to the location specified with the Substitution values replaced with the appropriate value. It does not matter if the Report is submitted for Generate Only, Print, or Preview - the file will also be written to the specified location. If the {Counter} or {Time} Substitutions are not used as part of the path or file name (Counter is only valid as part of the file name), a newly run report will overwrite an older one.


(Jonathan Lang) #3

I did not know that could be done. Works like a charm. Thank you Rich!