Zen Excel Report

Question

Question

Christopher de Melim · Oct 31, 2016

Hello Everyone.

Sorry if it is a dumb question, but I'm new.

First: I have to create a Excel MultipleSheet Report. That I'm fine with doing.. but they want me to give every Workbook that is created it's unique reportName, that is generated with the user input on the page. Is it possible to do so?

Second: I saw when creating the report.. Everything is placed in it's own column.. Is it possible to have some of the values next to each other and some Beneath each other.. Example.. BusinessProcess, TransactionType and NumberOfSteps must be next to each other and Step1, Step2 and Step3 should be beneath each other.. Is it possible to have it like this..

Thanks in advance

Christopher

Discussion (7)0

Log in or sign up to continue

Tomas Vaverka · Nov 2, 2016

Regarding your first question:

You can use a runtime expression as the value of excelSheetName. This is described in following documentation:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GRPT_report_running#GRPT_excel_multisheet

For example you can define property, which takes value from URL request:

Property SheetName As %String(ZENURL = "sheetname") [ InitialExpression = "Person" ];

And in the report definition:

< group name="Persons" excelSheetName='!..SheetName'
sql="SELECT top 2 name,Home_City as city,age,dob from Sample.Person order by Home_City"
runtimeMode="1">

Then you call your report like:

/csp/samples/ZEN.ExcelReport.cls?sheetname=SalesPerson

0 0

score 0 · Answer 1 · 2016-11-02T09:12:30-04:00

I am not sure if this is correct Community you posted your question. Please, what InterSystems technology (Caché, Ensemble) do you use to create your Excel MultipleSheet Report?

score 0 · Answer 2 · 2016-11-02T09:31:43-04:00

Christopher de Melim · Nov 2, 2016

We are using 2015.2.. If i understand you correctly..

Hope i'm on the right community..

0 0

score 0 · Answer 3 · 2016-11-02T12:11:09-04:00

Could you please provide some example how do you create an Excel report? What tools, what functions are used? Are you using Zen Reports?

score 0 · Answer 4 · 2016-11-02T13:00:14-04:00

Tomas Vaverka · Nov 2, 2016

I am sorry, I should read it more carefully, it is in the name of the topic - "Zen" Excel Report.

0 0

score 0 · Answer 5 · 2016-11-03T01:19:49-04:00

Christopher de Melim · Nov 3, 2016

Thanks Tomas..

I'll try the suggestions and thank you again later..

0 0

score 0 · Answer 6 · 2016-11-03T02:57:15-04:00

Hi Tomas..

I see that the link and code you supplied are for the sheet name.. I'm fine with that, Thanks for the link though, But what I meant was, if the report Page opens, It gives you the save option right? They want me to Generate a name for the Entire Excel document.. I saw that you can say

Parameter REPORTNAME = "ExcelReport";

But they want it to be generated with the userinput that is gathered in the zenPage that call's the ReportPage..

Thanks