cannot generate the output excel file

Last activity on October 1, 2023 - 11:21 2.4k Views 2 Replies Reports & Macros

XG

XT G on October 11, 2019

Hi everyone,

I want to create an excel using the report with the functions Context.createOutputObject() and WriteReport().

Actually it works now in report. But If I use Macro to execute the report, the excel file won't be generated.

There is no error message and the Macro is certainly correct. I have no idea why I can't get the excel file.

Also I used the same functions in other report but in that new report it also doesn't work. No error message but no output file.

Could anyone give some suggestions? What problems could it have when I want create an excel file? Thanks in advance.

Sign in or register to reply.

Notify Moderator

2 Replies

XG

XT G Author on October 15, 2019

Ok I find the problem.

In report, I have to add

Context.setSelectedFormat(...);

Context.setSelectedFile(...);

And in macro there should be setProperty.

Like

Sign in
or register to reply.

Notify Moderator
KF

Kay Fischbach on October 16, 2019 as Reply to XT G

I don't exactly know what your Macro looks like, but if you would use the correct methods in the Macro there shouldn't be a need to explicitly call .setSelectedFormat(...) and .setSelectedFile(...).

Does your Macro use a function called createExecInfo(...) to prepare the report execution? There are different versions of this method available, some with more parameters and other with less parameters. Use one of those functions that specifies the output format, output path and output file name, and there shouldn't be any difference between manually starting the report and letting the macro start the report.

Like

Sign in
or register to reply.

Notify Moderator

Upcoming events

Thursday, June 12, 2025 - 09:00

ARIS Super User Group Meeting

Sign in

Reset Password