jsreport forum

Yugam Gogia

My company just bought the enterprice licence .
Now i want to know how to use the key in Js report .
And apart from multiple templates what are the other benefits of enterprise version

Yugam Gogia

@jan_blaha ,
Getting error while doing Jsreport win-install

$ jsreport win-install
Platform is win32
Installing windows service "jsreport-server" for app..
Error: Command failed: "E:\Cartos_Main\Report\js-report\js-report\node_modules\winser-with-api\bin\nssm64.exe" install "jsreport-server" node server
'"E:\Cartos_Main\Report\js-report\js-report\node_modules\winser-with-api\bin\nssm64.exe"' is not recognized as an internal or external command,
operable program or batch file.

at ChildProcess.exithandler (child_process.js:275:12)
at emitTwo (events.js:126:13)
at ChildProcess.emit (events.js:214:7)
at maybeClose (internal/child_process.js:925:16)
at Process.ChildProcess._handle.onexit (internal/child_process.js:209:5) {"killed":false,"code":1,"signal":null,"cmd":"\"E:\\Cartos_Main\\Report\\js-report\\js-report\\node_modules\\winser-with-api\\bin\\nssm64.exe\" install \"jsreport-server\" node server"}

And how to see logs on linux server where it is deployed

Yugam Gogia

@jan_blaha ,Our Service is hosted on Linux server.
But the same issue with my local on windows, i got the logs from Event viewer
0_1526272690552_upload-d83cb992-7fd5-4931-9fbe-38a2fc0f430d

if Idle timout is causing this issue ,then what is the solution.
Please ignore the logged time ,as this is the first time i got this issue.

Yugam Gogia

@jan_blaha ,
m also facing similar issue,
This is the server log in my local,it automatically exit from the process :

2018-05-11T05:22:36.020Z - debug: Zipping prepared xml files into C:\Users\YUGAM~1.GHO\AppData\Local\Temp\jsreport\50840340-54db-11e8-908c-efa5b6c219fa.xlsx requestId=7
2018-05-11T05:22:36.093Z - debug: Successfully zipped now. requestId=7
2018-05-11T05:22:37.399Z - debug: Skipping storing report. requestId=7
2018-05-11T05:22:37.408Z - info: Rendering request 7 finished in 2071 ms requestId=7
2018-05-11T05:29:50.605Z - debug: OData update on templates

Process finished with exit code 1

Do you know how to avoid this.

Yugam Gogia

@bjrmatos any idea on this thread?

Yugam Gogia

Sure i will send u the zip.

Yugam Gogia

What is the attribute for custom format in jsreport xlsx recipe

As i want to fill the column with some color format.
My XML for my sample template looks like
-<sheetData>

</sheetData>

but customFormat= " " is not working in my handlers
Is there any alternate name for this

Yugam Gogia

I'm using Webstorm ...

if you try starting the server from normal cli console (without IDE), does it work? No it didnt but i tried on some other machine it was working.

One more doubt,for sake if i have 2 Tables and data on these tables is dynamic as we dont know how many rows it will populate(based on the json data we get)
0_1525064513637_upload-d87f4c86-a294-45a9-8415-da2e29b757d0

How do i get to know the starting index of second table where i need to start entering the data.(with osme function in helper i mnot getting the actual index)

Can you pleas help @administrators

Yugam Gogia

Thanks @bjrmatos for very detailed answer on styles.(It worked for me after reading your refrences)

Coming to helpers when i run my report with my local IDE code,the produced excel is not taking the helper function.

I think my IDE is not taking the reference of helpers.js in handlebar.

Do we need to add anything in config file or what.

I'm stuck on this without helper function my work will not move. 0_1524756181746_upload-e9e37333-5810-4bec-966f-83c4ec25c94f
0_1524756219102_upload-13238699-76ab-4ebc-823b-6dee05c55923

Yugam Gogia

ok i can take one more try with what you are reffering or if i can create the same template in js report with style ..if yes can you give me one example for styling the excel with jsreport

Also how do i include helper function in my content.handlebar in my IDE code.In playground it works but locally in IDE it is not working.

@bjrmatos any idea .

Yugam Gogia

Hi Team,

Can you help me in resolving this.
https://playground.jsreport.net/studio/workspace/ry0peD8pl/658
Unable to populate the data in excel.
I require the same template format/design as per the needs.
But when i m clearing all format it works.

Yugam Gogia

Yes it worked after i put the below code to recalculate the formula in my content.handlebars which do the same thing like ctrl +alt +f9
{{#xlsxMerge "xl/workbook.xml" "workbook.calcPr[0]"}}
<calcPr fullCalcOnLoad="1"/>
{{/xlsxMerge}}

Thanks @bjrmatos @jan_blaha for the support.

Yugam Gogia

I tried the same in playground it worked but not in my local when i put preview to false .. why the formulas/macro data is showing in excel online and not when downloaded directly ?
@bjrmatos any idea on this.

Yugam Gogia

While populating data on predefined formatted sheet ,i m getting sheet repair error on opening.Also the formulas also not working

Posts made by Yugam Gogia