I have an application where the user enter parameters for a report. I load these parameters in a .foc file along with their userid and a processed_sw. We use a .foc file so we can keep a history.

I have set up a RC job that runs nightly. The RC job has a pre-processing step that reads the file looking for any unprocessed rows. If the count is 0, I set &&KILL_RPC to 'Y', the rest of the job is not run and the job is then rescheduled for the next night. If a row is found, the job is run and the excel output is emailed to the user. After the job runs, a post-processing fex is run to update the processed_sw of the request just run.

What I need to know is, is there an easy way to have the post-processing fex, resubmit the job? That is, I want the RC job to basically keep running itself until all of the requests have been processed.

I know I could process all of the requests at one time and burst the reports on userid to get each user their report. But a user could make multiple requests and those requests need to be kept separate, so I don't see bursting as a viable option.

Thanks.

OK, I think I've found my answer. I can use the DSTRUN subroutine. However I have some questions about some of the parameters.

srv_userid - Is the reporting server id? Do I need this if the schedule to be run already has this supplied?

srv_userpass - same question as srv_userid.

httpuser/pswd - Our webserver is Win/2003 and use IWA. So I assume I don't need this or the associated length parameter.

Hello, I'm very new to this forum, so execuse me if I'm asking wrong question. It looks like you keep track of records processed by RC and I'm looking for similar functionality:
We are going to use ReportCaster for daily distribution of report. We don't want to send duplicate reports every day. The option we consider is to mark (Flag) records somehow in Database that such and such records were already sent. Is there a way to write Flag into SQL Database from WebFocus report (can we
insert/update records in database from report)?
If 'No', how can we avoid sending duplicate reports?
Thank you.
WF 7.1.6; SQL 2005; Report Caster

Seva,

you can use MODIFY or SQL UPDATE in a fex to update the flag.