Automated reports

New to kcml help? Introduce yourself here!
Post Reply
Posts: 2
Joined: Tue May 04, 2010 9:55 am

Automated reports

Post by cisco » Tue May 04, 2010 10:00 am

Can anyone please tell me if it is possible within ADP Kerridge to configure an automated report within Report Generator that can be sent via FTP/email?
I would love to know if this is possible.

Many thanks in advance,

Posts: 41
Joined: Tue May 19, 2009 3:34 pm
Location: Cheshire

Re: Automated reports

Post by sgnirtswob » Tue May 04, 2010 10:06 am

It is possible is the first answer. Unfortunantly I work for a different company now, still KCML coding (at the moment), so I am unable to remember or remind myself how to do it. Hopefully some one else will explain. Good luck. :D
Russell Smithers
XKO, Kerridge, ADP DSI, Bowstrings + Air Products

KCML Group ... _ug_grppro

Posts: 2
Joined: Tue May 04, 2010 9:55 am

Re: Automated reports

Post by cisco » Tue May 04, 2010 5:21 pm

If anyone could give further information with regard this query I would be most grateful.
Thanks, James

Posts: 6
Joined: Fri Apr 09, 2010 4:14 pm

Re: Automated reports

Post by kisam » Tue May 04, 2010 5:23 pm

Using report generator change output type to M and you should be able to send an email.

Then run the report through Timed operations

Posts: 13
Joined: Wed Sep 16, 2009 12:38 pm
Location: Bedfordview, Johannesburg

Re: Automated reports

Post by kccms » Wed May 05, 2010 6:43 am


Hope this will help for the ftp part. If you still need help with the email let me know.
How to setup a report to
(154.05 KiB) Downloaded 472 times

Posts: 7
Joined: Thu Jan 14, 2010 3:50 pm
Location: Cheltenham, England.

Re: Automated reports

Post by leizure » Thu May 13, 2010 10:58 am

Email reports

This is pretty straight forward.

Mark the report as 'M' as suggested.

In the derived you need a line that details the email header fields:

email_to$ = "": email_cc$ = "": email_subject$ = "Whats this email all about"

You can use prompts if required but you are limited to the field length:

email_to$ = !0_TO$ : email_subject$= !0_SUBJECT$

This will only email the output in plain text, pretty much unformated lines.

I understand you can attach RTF prints with 9304 and above (I'm on 9090) but the only thing I've been able to attach is HTML pages, which is much better formating than the plain text.

To do this mark the report as a HTML and use the predefined funtion 'rg_notify()

Posts: 12
Joined: Wed Aug 18, 2010 2:11 pm

Re: Automated reports

Post by keithtempleman » Wed Aug 18, 2010 2:16 pm

Hi, this is a joint introduction and hopefully an answer to the second part of your problem.

The mail side has been dealt with above using the standard inbuilt functions of RepGen, although you don't need to set the report to 'M' to use them, so the report can email you to tell you a file has been generated and all that good stuff. T

he FTP part can be done using an overlay and some variables that are set within the derived fields. Send me an email and I'll send you the overlay and full instructions.



Post Reply