Hi All,

I have created a device Excel and printing a report in excel device.

That report is getting printed and stored in server machine only and it is not giving any preview in client machine .

but according to my requirement that report also need to be stored in client machine also it must give preview.

I have given the following informations in excel device creation.
as below:

device:excel
device type:rewrite file
4gl program:ttstpconv
argument:ASCII:excel
path:e:\baan4\test.xls (this is my server machine path.)

if i give my client machine path , then also i am not getting report in my client machine.

Please give me some solution.

Thanks & Regards,
Mahes

Not sure about Baan running on windows, but attached is our device and baan runs on UNIX servers for us. We don't include a path. When we use this device a tmp file gets created in our client baan directory(c:\program files\baan\tmp) directory, excel gets launched(office directory is part of the path on our clients), excel pulls up the tmp file.

Now on win 7 we had problems initially because users did not have permissions to this tmp directory, but that was fixed. The desktop management group had to push out permissions to this directory for all our users. I am also not sure if we received any type of error message - been too long. I do know when trying to edit a script we would get a write error on the local directory.

As Mark has already mentioned , you dont need to type the entire path.
Either keep the path blank and provide the filename when device is used or
simply type in the filename(not full path) in "path".

Attached is the device data for Excel

Hi,


Thank You all for Your suggestions.

I tried to print report according to your suggestions.

It is not creating any excel file in the local machine , in the directory:
c:\programfiles\baan\tmp
But it i creating a notepad (.txt file )file in the same directroy, in the local machine.

and i am getting the excel file of report in the server machine as previously.

Thanks & Regards,
Mahes

That is what the baan excel device does - it creates a .txt file in the c:\program files\baan\tmp directory. It should then launch excel with this text file. So when excel opens you have a .txt file open - at no point does baan create a .xls file. If you want that then look in the code and utilities forum - you will find some examples on how to create this device driver yourself.

Note that excel must be in your directory path on the client or you must fully qualify the path to excel.

Hi,

I have a few questions.

1. Are you using a standard Baan device or creating one of your own?
2. If yes, then to create the file locally, are you moving the file from the server to the local machine through script (refer server2client)? No matter what path you give, I think the file gets created on the server.
3. To open the report in preview (Excel), you would probably need to give it an extension .xls and use the function app_start.

This can be achieved by having the above code in customized script of the session or a 3GL script attached to the device.

Regards,

Cyril Parathazham