XL Reports -Scheduled

HCL Domino Domino Forum
1

I am looking out for some XL reports which needs to be scheduled. The problem is , I ont have XL installed on the server machine due to company policy.

Is there any alternative way I can get some scheduled reports without having XL installed on server machine.

2

Subject: XL Reports -Scheduled

Hi,write the Output as HTML and then save the file with extension .xls

For Example, copy the below HTML into a notepad:

Font Test body {font-size:170%;} .f1 {font-family:helvetica;} .f2 {font-family:arial;} .f3 {font-family:univers;} .f4 {font-family:palatino;} .f5 {font-family:'palatino linotype';} .f6 {font-family:courier;}

Helvetica: This is a TEST for the font. 1234567890

Arial: This is a TEST for the font. 1234567890

Univers: This is a TEST for the font. 1234567890

Palatino: This is a TEST for the font. 1234567890

Palatino Linotype: This is a TEST for the font. 1234567890

Courier: This is a TEST for the font. 1234567890

Then save the file as test.xls

Look at the result by opening it.

HTH

Adi

3

Subject: RE: XL Reports -Scheduled

Thank you for the quick response…

I dont have file creation access on the server…and the above code requires a file to be created…

Can you please sugesst if there is any alternative for this.

4

Subject: RE: XL Reports -Scheduled

Without File creation access I don’t think it can be done.The file will get the attributes or properties of the extension (.XLS,.TXT,…) only when it is saved to the disk.You cannot send any report in Lotus by creating it on flight and without saving.

Hope this helps.

Cheers ,

RK Daparthi.

5

Subject: RE: XL Reports -Scheduled

Look in this post http://www.eknori.de/archives/1#more-1

Its is in german, but the reference to original coding is in english. There is also code-example

6

Subject: XL Reports -Scheduled

Use a local Lotus Notes client dedicated to the task with a local scheduled agent.

7

Subject: RE: XL Reports -Scheduled

how can I schedule an agent locally ?

8

Subject: RE: XL Reports -Scheduled

Pick “Local” as the server, and make sure that your user preferences (File->Preferences->User Preferences) have “Enable local scheduled agents” checked (under Startup Options on the Basics tab).