How to use jsrender engine for xlsx recipe with client application & webapi and jsreport embedded server.



  • Can you post the output log?



  • Error occured - Error during rendering report: Missing helper: 'xlsxRemove'
    Stack - Error: Missing helper: 'xlsxRemove'
    at new Error (<anonymous>)
    at Error.Exception (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\exception.js:13:41)
    at Object.<anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\base.js:66:13)
    at Object.eval (eval at <anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\javascript-compiler.js:171:23), <anonymous>:2:221)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\runtime.js:137:30)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\compiler.js:422:21)
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\handlebarsEngine.js:20:12)
    at evalmachine.<anonymous>:1:9
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\renderExecution.js:113:8)
    at D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\tasks\workersCluster.js:134:49
    From previous event:
    at Reporter.renderContent (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:183:38)
    at Object.reporter.extensionsManager.recipes.push.execute (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\extension\xlsx\lib\xlsx.js:72:29)
    at Reporter.executeRecipe (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:165:19)
    at dataProvider.startContext.then.then.then.then.then.then.fail.e.message (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:136:21)



  • This is actually just error. You should find in jsreport logs whats happening before.



  • It could be somewhere here D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\logs.



  • There are two files error.log and reporter.log. Which one i need to post?



  • The content of reporter.log.



  • This post is deleted!


  • This post is deleted!


  • We just need relevant part, probably at the end, few lines before the last error



  • Okay. Sorry for the inconvenience.

    2017-05-10T14:19:13.200Z - warn: Error when processing render request Error during rendering report: Missing helper: 'xlsxRemove' Error: Missing helper: 'xlsxRemove'
    at new Error (<anonymous>)
    at Error.Exception (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\exception.js:13:41)
    at Object.<anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\base.js:66:13)
    at Object.eval (eval at <anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\javascript-compiler.js:171:23), <anonymous>:2:221)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\runtime.js:137:30)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\compiler.js:422:21)
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\handlebarsEngine.js:20:12)
    at evalmachine.<anonymous>:1:9
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\renderExecution.js:113:8)
    at D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\tasks\workersCluster.js:134:49
    From previous event:
    at Reporter.renderContent (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:183:38)
    at Object.reporter.extensionsManager.recipes.push.execute (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\extension\xlsx\lib\xlsx.js:72:29)
    at Reporter.executeRecipe (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:165:19)
    at dataProvider.startContext.then.then.then.then.then.then.fail.e.message (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:136:21)
    2017-05-10T14:19:13.200Z - warn: Error during processing request: http://192.168.2.69/api/report?studio=embed&serverUrl=http%3A%2F%2F192.168.2.69%2Fjsreport.axd%3Furl%3D%2F details: Error during rendering report: Missing helper: 'xlsxRemove' Error: Missing helper: 'xlsxRemove'
    at new Error (<anonymous>)
    at Error.Exception (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\exception.js:13:41)
    at Object.<anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\base.js:66:13)
    at Object.eval (eval at <anonymous> (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\javascript-compiler.js:171:23), <anonymous>:2:221)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\runtime.js:137:30)
    at ret (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\node_modules\handlebars\dist\cjs\handlebars\compiler\compiler.js:422:21)
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\handlebarsEngine.js:20:12)
    at evalmachine.<anonymous>:1:9
    at module.exports (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\render\renderExecution.js:113:8)
    at D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\tasks\workersCluster.js:134:49
    From previous event:
    at Reporter.renderContent (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:183:38)
    at Object.reporter.extensionsManager.recipes.push.execute (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\extension\xlsx\lib\xlsx.js:72:29)
    at Reporter.executeRecipe (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:165:19)
    at dataProvider.startContext.then.then.then.then.then.then.fail.e.message (D:\Practice\jsexample\jsexample\App_Data\jsreport-net-embedded\lib\reporter.js:136:21)



  • Hey jan_blaha, Anything found from your side? I am eagerly waiting for the solution. Your suggestions are more helpful to me. Thank you for your valuable suggestions.



  • This still the exception, not the important logs which are BEFORE :)

    However I found out from the stack trace that you use very very old jsreport.embedded nuget package which doesn't have support for this advanced xlsx manipulations. You can see what will work with your current jsreport version here - https://playground.jsreport.net/studio/workspace/YBjmBsPFa/1

    I would recommend you to run standalone jsreport instance as separate server and communicate with it from your c# solution. Perhaps using jsreport.Client nuget.



  • Are the following commands enough to install complete jsreport server?

    npm install -g jsreport-cli
    jsreport init
    jsreport start


  • administrators

    @Kambhammettu yes, with those commands you will get the latest jsreport server.



  • I installed jsreport latest server. It started in port 5488 successfully. But may i know how to render report from client using jsreport.axd...embed.js reference??



  • Its working with few steps suggested in jsreport.net documentation using new server. Please ignore my previous question. Thanks for your help.


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.