Thanks, it's working today. Hopefully this is an issue that doesn't happen often.
Another question, for the credits, what makes up one credit unit and do they replenish on the 1st of the month?
Posts made by chriscrowley
-
RE: jsreport Online with SQL Server
-
RE: jsreport Online with SQL Server
I'm not sure what the performance issue is. It times out. Wasn't like that when we were still running a local instance of jsreport. We're still on the free tier until I can prove it works just as well as the local instance. Will we see a significant performance increase when we switch to the paid version? Could this timeout be related to the
jsreport.npm.require
?
-
RE: jsreport Online with SQL Server
Where is the config file located for jsreport Online?
-
RE: jsreport Online with SQL Server
Is it possible or advisable to add those two
require
lines to some global file that each of the report script files reference? Would it help at all with performance? -
RE: jsreport Online with SQL Server
Thanks! That worked. I'm glad I asked because ChatGPT and Copilot were saying it wasn't possible.
I replaced:
const sql = require('mssql');
With:
const jsreport = require('jsreport-proxy');
const sql = await jsreport.npm.require('mssql@latest');
-
jsreport Online with SQL Server
I successfully convinced my client to migrate from a self-hosted instance of jsreport to the cloud-based jsreport Online. This change was necessary as we're moving from a Ubuntu VM to Azure App Service, which doesn’t support self-hosted jsreport. However, after exporting all our reports and importing them into jsreport Online, we encountered errors due to the use of the
mssql
npm package. Is this package not supported in jsreport Online? We have tons of reports and all of them rely on connecting to SQL Server, which provides the JSON. I just assumed it was as flexible as the self-hosted version. Is there any way to connect to SQL Server and access the report data from jsreport Online?Thanks,
Chris -
RE: Merging static-pdf, orientation issues
I've having the exact same issue. Did you find a solution to this?
-
RE: Blank Page When Appending Reports
Upgrading to 2.11.0 did the trick. Thanks!
-
RE: Blank Page When Appending Reports
I'm afraid to upgrade to the newest version because it'll probably break stuff. Is it possible to upgrade to version 2.10.0?
Would the command line to upgrade be?:npm install @jsreport/jsreport-cli@2.10.0 -g
-
RE: Blank Page When Appending Reports
Is pdfUtils.removePages a newer function?
TypeError: jsreport.pdfUtils.removePages is not a function at Object.afterRender (evaluate-user-script.js:4:43) at __runAfter (/var/www/jsreportapp/node_modules/jsreport-scripts/lib/scriptEvalChild.js:127:28) at Object.base.apply (/var/www/jsreportapp/node_modules/vm2/lib/contextify.js:469:32) at evaluate-user-script.js:7:1 at Script.runInContext (vm.js:135:20) at VM.run (/var/www/jsreportapp/node_modules/vm2/lib/main.js:219:62) at run (/var/www/jsreportapp/node_modules/jsreport-core/lib/render/safeSandbox.js:183:19) at module.exports (/var/www/jsreportapp/node_modules/jsreport-scripts/lib/scriptEvalChild.js:170:5) at process.<anonymous> (/var/www/jsreportapp/node_modules/script-manager/lib/worker-processes.js:66:36) at process.emit (events.js:197:13)
We're using version: 2.6.1
-
Blank Page When Appending Reports
I have four 2-page "Order" report templates. These reports can be generated separately just fine. The user also wants to print all four reports at once. To do this, I created another "OrderAll" report, which is blank and under pdf-utils I added all four templates as "append", but now I have a blank first page. I could reorder them and set them all as "prepend", but then I get a blank page at the end (the best option, but still not perfect). If I set the first template template as "merge" it looks great, but it's missing the first template's second page. Is there an easier way to print four 2-page report templates at once without having a blank page?
-
Table Head Count
I'm trying to show the count out how many salespeople there are at the top of each page.
Is there an easy way to add this?My example code:
https://playground.jsreport.net/w/chriscrowley/74rbUvb9i.e.
Tom - 1/2
Tom - 2/2
TP - 1/1 -
RE: Print.js
I was able to get it working very easily. I post the JSON using XMLHttpRequest() and create a Blob using the response. Print.js can understand the response. The only problem is the option to set the filename when saving as PDF isn't working, but it's currently an issue on Github and hopefully will be addressed soon.
var pdfFile = new Blob([this.response], { type: "application/pdf" }); var pdfUrl = URL.createObjectURL(pdfFile); printJS({ printable: pdfUrl });
-
Print.js
I love your product and it creates great PDF reports, but they download as attachments. I'd like the PDF to display in a print preview like popup where the user can either save the rendered PDF as an attachment or print directly from there. I found a great open source JavaScript library called Print.js (npm install print-js) that does just that (examples). I can't imagine I'm the first person that wants to try to use both these great tools together. I searched online and this forum and found nothing. Before I try to integrate them myself I thought I'd first ask if anyone else has tried it and if so, is there any example code?
-
RE: Enterprise license Expiration Date
That's great news! That gives us more than enough time to have them renew the license. Thanks!
-
Shared Script
I currently have the following same config at the top of every one of my scripts:
const config = { "user": "username", "password": "password", "server": "localhost", "database": "DatabaseName", "options": { "encrypt": true } };
The location of my database and username and password has changed a bunch of times and it's a real pain to go into every script file to update this. Is there a better place I can put this so all the scripts have access to config and I only need to update one file?
-
Enterprise license Expiration Date
Our subscription expires on Thursday 11/5/2020 and we have a meeting with our client (who also pays for the license) on that very day to show them our progress. Will we still be able to use jsreport on 11/5/2020 or does it stop working the night before at midnight? We'll ask them to renew the license during our meeting, I just want to make sure we'll be able to show our progress first. There is a good change our meeting may be pushed back by one day to 11/6/2020. I assume that on Friday 11/6 it definitely won't work anymore?
-
Using pdfAddPageItem to Sum Totals per Page
I'm using pdfAddPageItem to add values which I want totaled in the footer of each page. The problem is it's totaling the entire report's values on the first page and doesn't get values for the rest of the pages.
Here is a playground showing the problem.
What am I missing?