 Report exported to excel [message #145627] |
Fri, 04 November 2005 04:55  |
sabmcg
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
i have a problem with formulas (CF).
They go to the end off the columns ...
example: (this is the way i want)
dept_number dept_descrition (CF) another_field1 .... another_fieldn
and in excel display's like this :
dept_number another_field1 .... another_fieldn dept_descrition (CF)
How can i put then in the rigth place ?
|
|
|
|
| Re: Report exported to excel [message #146014 is a reply to message #145627] |
Tue, 08 November 2005 03:09  |
eHeritage
Messages: 4
Registered: November 2005
Location: HYDERABAD
|
Junior Member |
|
|
Hi,
For exporting ur report data into excel u need to use different
printer file .
copy this code in notepad and save it as .prt file
/*****************/
printer "Excel"
height 5000
width 5000
code "500" control(I)
code "600" control(J)
/*****************/
and assign that printer file to desformat,
also u need to align the layout columns to fit to grid,
the first column u need to set printercodes as &500 and the last
column as &600.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
