Suggestion Please

HCL Domino Domino Forum
1

Hi,I need to do the following.

We have a Medical system on our AS400. The managers want a report in Excel from AS400, where it pulls in the days a person was on leave, but only show Weeks on the report. So it will total the Days off sick for every Week in the year. Is there a way I can do this through an agent, without the manager see the process of downloading and putting into Excel. They only want the e-mail with the report.

Any help in the right direction will be highly appreciated.

Thanks

Lieschen

2

Subject: Suggestion Please

Does it have to be Excel. You could just create a report on the 400, copy it to the IFS with CPYSPLF and CPYTOPCD or CPYTOIMPF, then pick it up from there with an agent running on your Domino Server. There is a News400 utility called CVTSPLSTMF that will give you a few more options such as PDF or HTML.

bvd

3

Subject: Suggestion Please

Or, you could have Excel query Notes via a web service request to an agent or form that would gather the data and send back the results.

4

Subject: Suggestion Please

HiIs there allready a connection to Notes? DECS ore someting. Otherwise I suggest a query on the AS and ODBC-Connection to Excel and do the rest in Excel.

Cheers Lieschen

cti

5

Subject: RE: Suggestion Please

Thanks guys.