The ZEN Reports documentation has a helpful trouble shooting section.

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...

I have found it helpful to save to <CacheInstall>/mgr/Temp all the intermediate files, the error messages from invoking FOP, the .xsl files, the .fo files, if any, and the PDF files.

The easiest way to do this is to set in the namespace from which the reports are being run, the following global: 

Set ^CacheTemp.ZEN("DebugZen","NoDelete")=1

There are three common sources of ZEN Report errors:

1) The ObjectScript code for invoking the report has errors.  Very often these errors can be found by examining %objlasterror, and if not, standard Object Script debugging techniques will often show the problem.

2) The generated xml or xsl or fo are invalid.  If you have a decent parsing editor such as XMLSpy Professional or Oxygen Editor, you can open each of the generated files in turn, with the appropriate editor.  If these editors find a problem such as an invalid tag or attribute, one can use FindInFiles on the reports searching for the names or attributes that are part of the error the editor detected to find the report in error, and the area in the report that is erroneous.  Since intermediate fo files are not always generated, and since fo files can be invalid in terms of the XSL-FO 1.1 standard, one sometimes needs to generate the fo files using the instructions in the ZEN Reports User Guide.

3) If all the files are valid, then it is still possible that FOP has emitted a Java exception stack for some reason.  These stacks can be seen by lookin at the .txt files generated in <CacheInstall>/mgr/Temp.

I hope this helps.

Jonathan Levinson

 

Our current Python binding only supports one dimensional lists.

I don't know of a work-around.

Please contact the WRC and discuss an enhancement request.  Product Management will decide whether the enhancement request is approved, and if approved when scheduled.

Thanks,

Jonathan Levinson

Senior Software Developer

InterSystems.

I don't understand the question.  Can you elaborate?

What is the request class?

In what way do you want to change the values in the SQL statement?

What do you mean by parsing the values in the excel report to report to each sheet respectively?

What you want to do in ZEN Reports cannot be done in ZEN Reports.

You cannot create an Excel spreadsheet whose headers are bolded.

You cannot create a default width for a cell.

Eclipse did not start as a Java IDE.  Eclipse had plug-in support from the beginning.  Java may have been one of the first languages supported, but Eclipse supports a variety of languages, including those, for instance, for Web development.

To install Java support, you need to do the following:

Help/install new software  

Click on available software sites

Put in the "Work with:" box http://download.eclipse.org/eclipse/updates/4.5.

Atelier uses the Mars platform.

From the check list pick what you want, but be sure for Java Development to click the check box - Java Development tools.

You'll also want to add http://download.eclipse.org/eclipse/updates/4.5.  There is an add button on your right.

Good luck!

Jonathan Levinson

Eclipse did not start as a Java IDE.  Eclipse had plug-in support from the beginning.  Java may have been one of the first languages supported, but Eclipse supports a variety of languages, including those, for instance, for Web development.

To install Java support, you need to do the following:

Help/install new software  

Click on available software sites

Put in the "Work with:" box http://download.eclipse.org/eclipse/updates/4.5.

Atelier uses the Mars platform.

From the check list pick what you want, but be sure for Java Development to click the check box - Java Development tools.

You'll also want to add http://download.eclipse.org/eclipse/updates/4.5.  There is an add button on your right.

Good luck!

Jonathan Levinson

This is a bug in my ANTLR grammar for ISC SQL.

I will fix on Tuesday and get back to you.

Would you mind attaching the code from above image, so I don't have to retype.

Thanks,

Jonathan Levinson