Parameters for Report starting via Job Scheduler

fve

Hi,

Our Sales-invoice Report is running a long time lately, so we would like to schedule to run our Sales Invoice Report during the night using the Job Scheduler.

Is it possible to use parameters, to run the report only for a certain period (e.g. run the report for all invoices of last week).

We would also like to schedule other reports this way.
So it would be nice to automate this with parameters for every report.

However, we don't know if this is possible.

Alex_Chow

Out of the box, no.

You'll need to set implicit filters in the report to print what you need.

kine

The reports can be customized and some "parameter passing" method can be used to set the parameters. It is not easy, but it is not too hard. I made it... :-)

Waldo

There is no way to make it 100% dynamically, because there is no way (in my knowledge) that you can pass a recordref to a REPORT.RUN - statement.

fve

Thanx for the replies.
Back to the drawing table

Marije_Brummel

Scheduling the report might be a solution, but have you looked at the queries that are in the report? You might be able to speed it up.

Depending if you are running SQL or C/SIDE you can use the client monitor and/or SQL Profiler to look at the statements and database usage.

What also often can help a lot is moving to Temptables before reporting and report on the buffers.

kine

Waldo wrote:

There is no way to make it 100% dynamically, because there is no way (in my knowledge) that you can pass a recordref to a REPORT.RUN - statement.

Yes, this PUSH method is not possible, but you can create support library with easy functions which you can use in the report to PULL the parameters. In this case you just needs to add few lines of code into each report you want to use in this module and you are done... :-)

Waldo

True, but for end users this is not really a "workable" solution. (can you even write code on a report when you buy a report designer granule ... ?).
Everything should be possible by just setting up some parameters...

kine

You can write code in report when you have report designer. And yes, it is not much enduser-frendly. But for developer it is just few minutes of work to extend some report when you have such a support library (plus testing etc. which can be much more). And yes, there is no general solution which don't require additional changes in code per report.

DenSter

Something like that is an easy thing for a solution center. I've done something like that to run MRP in the scheduler. What you'd have to do is add setup fields to store the parameters that the report should use, add some functionality to the report to be able to receive the parameters, create a codeunit to retrieve the parameters and set them into the report, and put the codeunit in the scheduler.

Waldo

What we have been investigating (and still are) is a way to expand our NAS Scheduler, to be able to dynamically schedule reports ... and pass filters. User shouldn't have to add code to any report.
It IS possible when you use a very (VERY) big CASE-statement, but that is off course not what we want . We also want to include custom tables dynamically.
We concluded this was a no-go, and we are handling these requests now the same way as you are mentioning.

DenSter

Should have called me Eric, I'd be able to tell you in two minutes

kine

DenSter wrote:

Should have called me Eric, I'd be able to tell you in two minutes

Me too... :-) :whistle:

Waldo

Yes, but I never take "no" for an answer
Therefore ... still under investigation (luckily not fulltime )

themave

As an end users we do this, and you don't really need your solution center to do it for you, make a copy of the report you want to run, leaving your original intact, makes future upgrades much easier, and you can test it without missing up your original.


Then make a small modification to the new report. since we know when we want to run it, say each Saturday night in the job schedular. we know what the filter needs to be.

it needs to be the range

(today -7days) to (today), that covers the full week

so we add two variables to the report

FromDate := TODAY - 7;
ToDate := TODAY ;

then set your filter using the above dates

Record.SETFILTER(Field, String, [Value],...)

so depending on the report,

"Sales Invoice Header".SETFILTER(DateFilter,%1..%2,FromDate,ToDate)

This is definitely within your ability to do, with a little practice. I am sure it can be done a lot better by a solution center, they can make a separate NAS job scheduler for you, modify the reports, ect ect ect, and in a month or two you can have it working, or you can spend a little time right now, get it done a little less eloquently, and be a lot smarter for the effort.