Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Charts used with Powerbuilder datawindow ending up as PDF

  1. How-to
0
Votes
Undo
  1. Torgeir Lund
    Torgeir Lund
  2. PowerBuilder
  3. Wednesday, 7 June 2023 09:41 AM UTC

Hi, we are as writing testig our migration of our Application from PB 11.5 to PB 2022. The migration went well, with some changing of oure use of java. (ActiveMq JMS to Active Mq NMS)

The application is a layout generator that makes 10 thousands of reports per job with high performance in mind. We create financial multipage reports for our customers end users and the reports includes chart presentations as pie chart, line chart, bar charts and so on. We are using the eol active control First Impression by Tidestone Inc.

This can run with PB 2022 (32 bit not tested with 64bit), but we are looking for new thirparty chart products to replace the activex control. We are  dependent on saving charts as image on disk to be embedded in our datawindows, so the thirdparty product should support this.

We are wondering if there are others in the PowerBuilcer community that uses charts in their reports and what chart product you could recommend. High performance in rendering and saving the charts to file is very important.

Regards Torgeir S. Lund

  1. Graph
  2. PowerBuilder (Appeon)
Dynamic CrossTabs
Row changed between retrieve and update
Responses (2)
Torgeir Lund
Torgeir Lund Accepted Answer Pending Moderation
  1. Thursday, 8 June 2023 08:35 AM UTC
  2. PowerBuilder
  3. # 1

A following up question. With PB 2022 posibillities to import .Net DLL's, is there anybody that have tried to create a .Net DLL that creates charts from data delivered from the PB application and saves the Chart as an image (*.png) to be used in the datawindow.

Is this a way to go or is the WebBrowser soultion more common way to use charting in PowerBuilder, with performance in mind?

 

 

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 9 June 2023 16:37 PM UTC
I can't tell you anything about performance differences, but I've used both C# Standard charts (wrapping it into an ActiveX) and also have experimented with the Apache E-charts. The disadvantage of E-charts is that you have to distribute a whole bunch of JS files and the disadvantage of the C# solution is that you have to create a new installer (which is a pain if you use Wix installer) of your wrapper every time you do changes and "welcome to GUID hell". (at least for a noob like me in C#).
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 9 June 2023 16:39 PM UTC
The good thing about using C#, is that you can practically do whatever you want with them. What about using the improved graph datawindows of PB 2022?
  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 7 June 2023 13:04 PM UTC
  2. PowerBuilder
  3. # 2

GitHub - Appeon/PowerBuilder-Graph-Example: The Graph example project shows you how to use the PowerBuilder WebBrowser control and a third-party charting library (such as ECharts or Google Charts) to present intuitive, interactive and highly customizable charts in your PowerBuilder application.

 

 

Comment
Torgeir Lund
  1. Torgeir Lund
  2. Wednesday, 7 June 2023 13:12 PM UTC
I will look into that thanks Mike
  1. Helpful
Torgeir Lund
  1. Torgeir Lund
  2. Friday, 9 June 2023 12:13 PM UTC
Hi Mike, I have been looking at echart via PB WebBrowser it works fine, but do you know how I can save the rendered chart without toolbox and clicking the download button. Our application is none visual an non user interaction, so we need to save the each created chart on the fly to an unique specified path, and filename.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 9 June 2023 15:46 PM UTC
The WebBrowser control supports JavaScript code execution, so if the charting library you are using has a JavaScript function for printing then you should be able to call that from your app. The JavaScript chart is not a feature of PowerBuilder itself and there are many charting libraries, so you would want to evaluate which chart library to use and the echarts is example/demo.
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.