Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th January 2011, 14:09
maheswar's Avatar
maheswar maheswar is offline
Junior Member
 
Join Date: Oct 2010
Posts: 21
maheswar is on a distinguished road
Baan: ln6,BaaNIV - DB: mysql - OS: windows xp,NT
Exclamation Excel Report In Client Machine
Baan: Other/Unknown
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 13th January 2011, 14:54
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
Attached Images
File Type: jpg excel.jpg (77.5 KB, 72 views)
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 14th January 2011, 05:33
NirajKakodkar's Avatar
NirajKakodkar NirajKakodkar is offline
Guru
 
Join Date: May 2006
Location: Finland
Posts: 339
NirajKakodkar is on a distinguished road
Baan: BAAN4C4 , BAAN 5c , LN - DB: MS SQL SERVER, ORACLE, Informix, HP Unix, AIX - OS: Windows, UNIX
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
Attached Images
File Type: jpg excel.JPG (47.1 KB, 54 views)
__________________

Niraj N. S. Kakodkar |Linkedin
Reply With Quote
  #4  
Old 17th January 2011, 05:30
maheswar's Avatar
maheswar maheswar is offline
Junior Member
 
Join Date: Oct 2010
Posts: 21
maheswar is on a distinguished road
Baan: ln6,BaaNIV - DB: mysql - OS: windows xp,NT
Exclamation Excel Report

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
Reply With Quote
  #5  
Old 17th January 2011, 14:58
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

Last edited by mark_h : 17th January 2011 at 16:38. Reason: Spelling
Reply With Quote
  #6  
Old 17th January 2011, 15:54
cyrilchacko cyrilchacko is offline
Junior Member
 
Join Date: Aug 2008
Posts: 25
cyrilchacko is on a distinguished road
Baan: various - DB: various - OS: various
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
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CODE: Simple report conversion for excel richard Code & Utilities 17 12th February 2013 11:56
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
solving recursion problems rmarles Tools Development 2 25th January 2005 21:23
BW Client machine continuously reboots djain999 Tools Administration & Installation 4 27th June 2003 09:07


All times are GMT +2. The time now is 13:31.


©2001-2017 - Baanboard.com - Baanforums.com