Auto Report

Kinetic ERP
,
1

I started with a new company whose reports are all in SQL. Meaning they are written in SQL not in Epicor then pushed to SSRS. The reports are viewed by the end user going to Epicor, clicking the name of the report, that then sends them to the ssrs webpage of that report. So, any parameters have to be entered and then the report will show the data.

I have a request forma user on one of those reports. She has to enter four different sets of parameters and the run the report in order to get all of her data. She then exports it to Excel and uses it locally on her computer. While I am looking to see why she isn’t using Epicor, for now, she is wanting to automate the reports to be ran. After thinking on this, I can’t think of any good ways to run this report with 4 different sets of parameters and have it run three different times per day.

Any ideas on how this could be accomplished?

2

Look at this post to see if it helps.

Rest - Passing Parameters from Cell in Excel to Rest Query in Power Query Editor - Kinetic 202X - Epicor User Help Forum (epiusers.help)

1 Like
3

Taht is an interesting idea. Do you know where I can find the list of API’s? Because our reports are not in BAQ’s. They ware wrote directly in the report in SSRS in the Query Editor.

4

That’s right, I did not put 2 and 2 together. You could always just build a connection to the DB in Excel and then copy and paste in the query from the RDL.

5

Well you could start rewriting them…