Posts made by palphonse

Hello thanks for your reply.
we opened the port 5488, ,but we are unable to reach the jsreport report server. Is there any configuration needed.
We are launching jsreport with
node server.js

Thanks alot.

Is there anyway to run jsreport to be visible over the internet?
not just localhost

Hello,

Can JSReport be installed on Windows Server 2008 R2?
Thanks

Hello we already enabled debug logs in the config file, please find the link to the reporter.log file (we were not able to attach it here)The error.log file is empty.

https://we.tl/t-ZHCwh4PF8F

Thanks

Hello again,
Please note that we are using a server with 16 CPUs.
We tested by doubling the numberOfWorkers in the jsReport config starting at 1 up to 16, with concurrency = numberOfWorkers x 4 ( from 4 till 64 respectively)
Using this setup, we didn't get any noticeable performance boost after numberOfWorkers = 2 and concurrency = 8.
However, executing the same setup without fetching data from DB resulted in better performance all the way till numberOfWorkers = 8 and concurrency = 32.
During the report generation, we monitored the SQL server and it was running under 20% of its maximum CPU usage since we used a very simple SELECT query.

Below is a link to the requested log (I was not able to attach the file to the message).
The log was for numberOfWorkers =16 concuurency = 64

https://we.tl/t-ZHCwh4PF8F

Thanks

thanks,

so from what i understand jsreport will not process multiple sql queries in parallel?

Thanks again, I encountered a small problem when the scheduled template is calling the second template. In the second template req.options.scheduling.schedule is also true, however it is not being called from the scheduler but from a scheduled template. How can we differentiate between them?

Hello Im currently using version 2.7.2, how can we update to the latest version without losing the work we have done. Please note that we are using mssql-store to store all the jsreport info in our db. Will the new version have the same DB structure when updated?

Thanks

Hello, Thanks this worked, however I noticed that the nextRun field isn't updated automatically unless i disable then re enable the schedule.
Is there any other way to do it automatically? Other that setting this field manually as well?

Hello, Thanks for the reply it was very helpful. Can we use the tag field in schedules to store specific params to be used when this schedule is called. So we can have multiple schedules for a template, and each schedule has a set of params in the tag field. Is this possible?

Thanks

Hello,

Is it possible to call an API to clone a specific template?

Thanks

Hello,

I'm trying to find a way to schedule a report with parameters, as well as being able to render it on the spot by calling the api and providing the parameters. What is the best way to go about this?
Thanks

Hello again, I tried the sample, and i noticed a few seconds difference, however when I run my template, no difference is noticed.Could this be because we are using mssql to get data from a db?

Ok thanks I will try it. The difference is that the second template that is being rendered uses mssql to read data could this be a reason?

Hello, thank you, these are the settings i had, i also used 2 for both

Hello again,

I set the numberofworkers to 4, and set concurrency to 4 in bluebirdjs and trying to render 1000 requests for the purpose of testing. It is working, but I didn't notice a difference in performance if i changed the numberofworkers to lets say 2 or 1.
Why could this be?

Thanks

Hello again,

Just to recap my problem.We are using chrome-pdf to run a scheduled report, when it's time for the report to run, we need to generate a report for a large number of users (could reach 100,000) So we would need one scheduled template (template 1) to render another template (template 2) with a specific parameter. So template 1 would need to render template 2 100,000 times.
From what I understood from your help and the documentation, we would need to adjust some settings in the config file and use a module to split the requests made to template 2 from template 1. Is this correct?
Could you please advise on what settings would be needed, and how to go about this?
Thank again

Thanks again,
Sorry I'm new to JSReport and node.js, technically what would be the best way to render for example 100000 returned records that we are looping over.
Would we need to use "await" if the calls to render are split into workers or will JSreport handle this.

Thanks

Thanks again.
Lets say there are 1000 records that we are looping over, so we will have to call render 1000 times. How will JsReport handle these requests. Will they be divided among different workers or just 1 worker.

Thanks

Hello,

I am looking for a way to update the cron schedule for a template via an API call is this possible?

Thanks