1. Systeembeheer SFR
  2. PowerBuilder
  3. Wednesday, 6 October 2021 10:27 AM UTC

Hi

I am look for a way or exaple to make a plan bord in powerbuilder

I have the data from jobs with dates in the DB

I want to create something like this picture below. I tryed to make it with a graph but dit not succed yet. 

Anybody some ideas of exaples laying around

Cheers

 

Shekar Reddy Accepted Answer Pending Moderation
  1. Wednesday, 6 October 2021 16:01 PM UTC
  2. PowerBuilder
  3. # 1

You can create dynamic Gantt Charts or Timelines using pure PowerBuilder logic with text controls inside a tabular DataWindow, drawing grid lines for time periods with major lines and minor lines (sub-divisions) and setting X, Width, Color (text color, bar color), scaling factor, etc. for text bar controls as dynamic expressions using dynamic data. I did it once and also added a Today date-line and made it reusable. If you wanna make your DW-based timeline chart reusable, you prolly want it to be an External DW and insert dynamic data into it manually at runtime using a datastore, etc.

However, there is now an easier and a more elegant way to implement Timeline charts using the integrated Google Charts in PB (without using DW). Check out the w_Timelines window in GoogleCharts target inside Example Graph App workspace from Appeon along with all the PowerScript code. Run the target to view the chart.

You can also install and run the compiled PowerBuilder/PowerServer demo versions from here -

https://demo.appeon.com/?powerbuilder

 

 

 

Run the GoogleCharts target -

 

HTH

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 6 October 2021 14:04 PM UTC
  2. PowerBuilder
  3. # 2

To me, it looks like a simple grid datawindow. For example, you could use computed columns in the SELECT of your datawindow or in some hidden columns to be used for the background colour attributes.

regards.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 6 October 2021 13:49 PM UTC
  2. PowerBuilder
  3. # 3

Hi Systeembeheer;

  Suggestion: How about using a CrossTab DWO?

For example:

FWIW: You can delete the extraneous computations both vertically and horizontally if need be to simply even more.

Food for thought

Regards ... Chris

Comment
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Wednesday, 6 October 2021 10:29 AM UTC
  2. PowerBuilder
  3. # 4

dw-extreme may be the one which you require.   More details at

http://www.dw-extreme.com/

 

Comment
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.