Question
· Mar 14, 2018
ZEN REPORTS and EXCEL

I have a ZEN report set up to generate a file for loading to into excel (see attached). Even though I have DEFAULTMODE set to "excel" the resulting output file that I get on one CACHE instance is .xml while on another it is .xls. This is even though I run the report from the two instances on the same PC. Can anyone suggest what I am doing wrong? The Cache version is "Cache for UNIX (IBM AIX for System Power System-64) 2013.1.6 (Build 950_1) Fri Jun 6 2014 17:43:51 EDT"

0 4
0 470

I have a dataListBox in ZEN which has an OnDrawItem method associated with it. The DrawItem method never seems to be called and I cannot see why. I am using IE11. Can anyone suggest a reason? The attached code runs in a namespace called CODE and can be run using view webpage on the TheLabsApp.BioAnal class. Please note that the data is in a global called ^%ANAL that resides in %SYS.

1 3
0 237

Hi Guys,

I would to know, I have a drop down list items in my applications. While, am clicking on the drop down bx, there are few numbers of listed items, while am doing mouse over action, I should display the entire text of selected item from that drop down list box, even am not selecting that item. I would like to know about the what is exact text it contains in Zen framework.

If any lead would be appreciated.

Thank you in advance.

0 13
0 1.1K

Hi,

I would like to set the report headerHeight dynamically based on a group records count.

Example:

If GroupA has 5 records then the headerHeight should be 50mm

If GroupA has 3 records then the headerHeight should be 30mm

Could you please advice the best approach to achieve this?

Thank you,

Rui

0 1
0 234

Looking at the documentation expalining the use of client side menus, including the drop down menu.

I was messing around trying to get the "Open", once clicked, to use javascript to open windows file explorer to open/pick a file.

I've got it to partially work... Using keystrokes Ctrl-O will open the file explorer yet clicking on the drop down's File/Open does nothing.

Not sure what I'm doing wrong here.

NOTE: I had commented out the two &html lines in the Testing Method... and doing a Ctrl-O still work.

Why?

0 2
0 340

Hi

Is it possible to include the ≥ or ≤ in a ZEN select component? i.e.

<select id="condition" label="Condition" valueList="&lt;,&gt;,=,≤,≥" displayList="&lt;,&gt;,=,≤,≥"/>

I have tried &ge; and &le; but these also do not work. If I inspect the options in the browser and edit with these characters they display correctly but just not when loaded in the zen page.

Cheers

Iain

0 10
0 279

Hello, I am trying to get the Zen Print Server to work so that i can use the pdfprint mode in Zen Reports. Zen Reports will create pdfs just fine, so that part is working. And the printer works fine from other applications on this computer and I have verified the printer name a bunch of times.

This is Caché 2016.2 on Windows 10. I have tried this using Adobe 11.0 and Adobe DC. I have made and started a Zen Report Print Server with

Name = "ZenPrint"

Port = "4321"

and Ping Port = "4320"

0 4
0 254

"Help me, Obi Wan Kenobi"?

I’ve hit the wall. I’m a one person shop who wants to start developing Cache on a mac using Eclipse/Atelier, after using Studio for the last 5 years. I’ve installed the 1.1 beta plugin, watched 6 or 7 videos from the September conference, tried several times to work through the cheat sheets, only to have connection issues or compilation issues, so at this point, I’m feeling very frustrated. The videos were interesting, but generally didn’t work as tutorials for fundamental programming operations, for me.

0 3
0 311

I want to limit the length of the value of a textarea in Zen. In HTML the textarea element has a 'maxlength' attribute, but the Zen component doesn't have an equivalent property. Is there any way to add a maximum length in Zen short of creating my own custom component?

1 3
0 654
Question
· Oct 14, 2017
ZenMethod in onunloadHandler

I want to call ZenMethod when page is closing. Is it possible?

I tried

ClientMethod onunloadHandler() [ Language = javascript ]
{
zenPage.SomeZenMethod();
}


Method SomeZenMethod() [ ZenMethod ]
{
// to do some work
}

0 1
0 332

Hi everyone! My company has a Zen ERP application with CSP delegated authentication. Now, we're developing a separated BI application, using Angular, which consumes DeepSee REST API services. Both applications access the same Caché database.

How to implement single sign-on strategy in order to allow an already authenticated ERP user to access DeepSee REST services? Has anyone already implemented something like that?

Thanks in advanced.

0 3
0 529

When I add a parameter to dataCombo for loading it on runtime and the property editable set to 0, dynamically loading content for dropdown through parameter works fine.

But, when I set editable to 1, to implement user search in dataCombo, loading through parameter is not working, it is loaded all rows, but I need loading on some parameter. It don't see the parameter, when editable is 1.

Is it normal behavior of dataCombo? But how about user search in dataCombo on this case? When editable is 0, we can't enter any character in dataCombo.

0 2
0 314

I have a <tablePane> element with OnCreateResultSet and OnExecuteResultSet methods; autoExecute is "false" but the OnCreateResultSet and OnExecuteResultSet methods are nevertheless called on page load.

I want the user to be able to press a button to submit the parameters, then have this button call tablePane.executeQuery() to execute the query.

autoExecute is simply igonored. We're on 2014.1.3 with plans to upgrade to 2016 soon.

Are there more settings I need to set? Or is this attribute simply ignored?

0 5
0 348
Question
· Aug 25, 2017
Zen Report - ErrorNo: 5540

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

Regards,

Rui

1 4
0 407

The dataCombo property columnHeaders is a comma-delimited list of column headers displayed in the dropdown list.

Comma is a delimiter.

But, if I want add comma to columh header, for instance "House number, apartment" - this is value for header of one column.

How can I escape comma in this case?

"House number\, apartment" - is not working.

0 26
0 499

Greetings!

I'm new to Zen reports and I'm wondering if what I'm trying to do is possible. I have a classmethod that accepts three parameters to generate an xml file from a global. I've set up my Report Definition to call the ClassMethod that generates the .xml file; however, I'm trying to figure out how to pass the parameters to that ClassMethod from the Report Definition. The example in the documentation shows parameter passing using SQL (which I'm not using), so I'm curious if this will work.

0 2
0 362