Hello All

I required the output of Excel Device in Local System and in proper format without doing conversion after opening the file in Excel.

For example, after i give the device i can give the o/p but its at Server side, Can i give it at Client side?

And

Can i want all the formatting in the file so that when user opens the file it opens in a proper format.

Many of us would have thought in these lines. So it must be done before?

Hi,

That is not possible without writing your own device, as far as I know. The other solution is exporting the report data to sequential file and then opening it in Excel, with whatever column separator you want. But it requires writing / modifying report script of all concerned reports.

Vishal

As of Infor LN 10.3 you can define a device of type External Reporting Service and argument: -excel -open. It opens an Excel workbook with the raw data of the report formatted in columns. See example in attachment.

You can also look in the code and utilities forum for excel solutions. What we do is write macros on our 4c4 system. The user runs the session, picks our PCEXCEL device, which takes the report and runs the macro for that report to format it how the users wish to see it. Usually the macros are not just simple formatting, the users can typically do that themselves.

As of Infor LN 10.3 you can define a device of type External Reporting Service and argument: -excel -open. It opens an Excel workbook with the raw data of the report formatted in columns. See example in attachment.

I defined the parameters like this. Are the parameters Ok?

I am getting an Error when i select the defined device.

Hi,

Attachment is missing. I guess, the solution recommended by Jaap will only work in LNUI.

Bhushan is right, although with WebUI it will work as well.

You can also look in the code and utilities forum for excel solutions. What we do is write macros on our 4c4 system. The user runs the session, picks our PCEXCEL device, which takes the report and runs the macro for that report to format it how the users wish to see it. Usually the macros are not just simple formatting, the users can typically do that themselves.


How do you call the macro?

Basically we have a device which has 3gl script attached as the program. What this does is takes the report in the $BSE/tmp directory and converts it to an ascii file. You can see how to do this in the Code and Utilities forum. So for the fileout the user puts in what we call site. This allows us to have multiple macors for the same report to run for a different set of users. You could have USA - macro1, CAN - macro2 - all for the same report name. At this point pretty much every uses the same macro so we have a site called "ALL"

Then we have two tables one holds the site and where excel is located (not really needed since all of ours sites are now the same for excel). Then we have another table than holds the report name, where the converted file gets downloaded to, and what the macro name is and where it is stored. So basically the below code builds a command like excel.exe \\soemfileserver\maindirectory\subdirectoy\macroname. It then does an app start on the command.

function start_excel_with_macro()
{
string appl(132), parm(215),start(1024)
long app_id, rc
| Setup application to start and macro name

select tuddc906.*
from tuddc906
where tuddc906.site = :spool.fileout
as set with 1 rows
selectdo
endselect
appl = tuddc906.loca
|appl = "C:\program files\microsoft office\office\excel.exe"
parm = strip$(tuddc905.macl) & tuddc905.macr
start= appl&" "&parm
| Start the apllication
app_id = app_start(start,"","","","")

rc = app_status(app_id)
if(rc = 0) then
message("Application start failed.")
endif
}

Hi,
I guess B2WIN is also good option as far as different formats output and formatting is concerned.

Also if someone wants to do it themselves, as suggested by Mark in above threads;one can make use of Macros.There are examples related to Macros in the forum

Refer sourceforge.net
https://sourceforge.net/directory/os:windows/?q=baanex
Perfectly working and refer video in youtube as well for configuration
https://sourceforge.net/projects/baanex/?source=directory#screenshots

Refer sourceforge.net
https://sourceforge.net/directory/os:windows/?q=baanex
Perfectly working and refer video in youtube as well for configuration
https://sourceforge.net/projects/baanex/?source=directory#screenshots

are you success using it?
i try not success.
u can give me information for it?

Yes, I was succesful but the report should be linear.