Question Nezla · Jan 18, 2022 Export Zen report to Excel DEFAULTMODE ="xlsx" Hi Guys, I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server? Thanks #Ensemble 0 8 0 443
Question Nezla · Nov 25, 2021 Excel Runtime EXE Hi Guys, is there a Runtime EXE for Excel or ms office, I've a report that would like to open in excel? Thanks #Ensemble 0 3 0 1.8K
Question Nezla · Nov 16, 2021 Export Zen Report or Query to a CSV file Hi Guys, How can I download or populate a query resultset or a content or DataGrid or zen report to a CSV file ? #Ensemble 0 9 0 540
Question Nezla · Nov 2, 2021 textarea in tablepane cell Hi Guys, I've bind a textarea to show up in a tablepane cell and it's working fine as follow: this the column injh question: #Ensemble 0 4 0 190
Question Nezla · Oct 27, 2021 Including datetext in a table pane Hi Guys, is there a way to include a datetext in a tablepane cell maybe using OnDrawCell? I've tried : &html<<input type ="date" id="serialno" style=" width: 80%;" />> #Ensemble 0 4 0 187
Question Nezla · Oct 19, 2021 Change Font Colour in tablepane Hi Guys, How can I programmatically change the font colour in column in tablepane, for example to text in a specific column to be red, maybe that could be done in %OnAfterCreatePage or OnDrawCell ? Thanks' #Ensemble 0 2 0 202
Question Nezla · Oct 14, 2021 Lock the Modal View Hi Guys, I'm using a Modal Group but whenever I click outside it the Modal gets minimised, so How can I change the view so that whenever pops up the view get locked until I'm finished with my modal then click exit to endModal ? thanks #Ensemble 0 3 0 327
Question Nezla · Sep 23, 2021 Using Arrow with left join Hi Guys, my understanding that Arrow can't be used in left or right joins as the example below, so is there an alternative ? SELECT Sample.Employee.Name, Sample.Company.Name AS CompName FROM Sample.Employee LEFT OUTER JOIN Sample.Company ON Sample.Employee.Company->Name = Sample.Company.Name Thanks #Ensemble 0 2 0 450
Question Nezla · Sep 8, 2021 Force YYYY format Hi Guys, when using $ZD(mydate,4) sometimes it returns year as 4 digits and sometimes two, and the documentation is saying ([YY]YY is a two-digit year if hdate falls within the active window for two-digit years; otherwise it is a four-digit year), what active window for two means and how can I force the year to be always 4 digits ? Thanks #Ensemble 0 2 0 245
Question Nezla · Aug 17, 2021 Hidden attribute is not available Hi Guys, Would like to know how to hide an element or component in zen report? I've a list of element (eg. table, images, items..etc) defined under XData ReportDefinition [ XMLNamespace = http://www.intersystems.com/zen/report/definition ] { #Ensemble 0 1 0 173
Question Nezla · Jul 29, 2021 Export zen page to CSV Hi guys, I've a zen page report that I would like to export to .csv file, any ideas on how to do that? Thanks #Ensemble 0 5 0 481
Question Nezla · Jul 11, 2021 Applying Stylesheet Hi Guys, I'm using the below style and everything looks good, with my Dynamic Grid width 1300px, but when I refresh my grid the width goes out of whack and the grid is too wide, so how can I re-call my enforce my style to be applied again after refreshing my grid, so basically I'm looking for a line of code that I add it to my refreshing () clientMethod ? XData Style{<style type="text/css">body { padding: 5px; margin: 0px; height: 100%; background-image : url(images/bkground.gif);} #Caché 0 1 0 170
Question Nezla · Jun 30, 2021 OnMouseOver in a TablePane Hi Guys, is there a Onmouseover event in TablePane? I'm looking to show an image when the user hover with the mouse on a specific Cell in a tablepane, any Ideas? Thanks' #Caché 0 1 0 156
Question Nezla · Jun 30, 2021 Wrapping lines in Dynamic Grid Hi Guys, The lines in my dynamicGrid are getting chopped off and not wrapping to the next lines, how can I make rows wrapping to the next line pls? Thanks #Caché 0 1 0 276
Question Nezla · Jun 27, 2021 Call client method %OnAfterCreate page Hi Guys, how can I call a client method inside %OnAfterCreate method? thanks #Caché 0 2 0 172
Question Nezla · Jun 25, 2021 clear selection tablepane Hi guys, how to clear selection in a table pane? Thanks #Ensemble 0 4 0 234
Question Nezla · Jun 24, 2021 Adjust tablepane rows Hi Guys, for some reason the height in my tablepane are very big, how can I adjust the height in the rows in a tablepane? Thanks #Caché 0 5 0 178
Question Nezla · Jun 23, 2021 findElement("input").value is not working Hi Guys, I've a combo inside a tabGroup inside a form and using : var MyInput = zen("MyCombo").findElement("input").value; is not finding the current input, any help pls? Thanks #Ensemble 0 3 0 137
Question Nezla · Jun 8, 2021 displaying %GlobalCharacterStream Hi Guys, I'm wondering how can I get fields defined as %GlobalCharacterStream diplayed in a SQL query or even objects? I've some data that I need to convert over to a new system and the old uses %GlobalCharacterStream data type for one of its fields and I''m unable to display or extract to a spreadsheet, any help pls? thanks #Ensemble 0 13 0 1.2K
Question Nezla · May 23, 2021 HL7 learning Hi Guys, I'm new in HL7 and have seen the basic learning material in "HL7 Business Services and Business Operations" but I'm wondering if there are learning materials and samples that I can boost my HL7 knowledge pls? Thanks #Ensemble 0 4 0 286