PowerBuilder-Centric

We are pleased to announce that we are taking our flagship TechWave conference around the world this year.  In response to numerous requests from customers and partners, we will be holding regional TechWave events in major global locations during the second half of 2009.

Last year’s TechWave conference received the highest customer satisfaction marks in the 10 year history of the event.  By regionalizing, we hope to provide opportunities for even more of our customers to participate.  In addition to the high quality educational content and networking opportunities our attendees have come to expect from TechWave, we also plan to offer expanded business and vertical content tailored for each region.   

Be sure to bookmark http://www.sybase.com/techwave, where all the latest and greatest information will be posted as it is available, including dates, locations, and agendas.

Download Source

As of PowerBuilder 11.5, DataWindow columns can have background gradients. In that gradients can be data-driven by expressions, this tip will review how columns can emulate bar graphs.

For this example, I’ve created a DataWindow object that displays sales orders by sales rep and I’ve created a computed field that displays each rep’s quantity of orders as a percentage compared to the total count of orders for all sales reps.

To have the column’s background gradient behave as a bar in a bar graph, first institute the background gradient itself. Here I’ve chosen a horizontal gradient that will be blue in color.

Next, I’ve set the gradient’s Transparency, Angle and Focus to a value of zero, and the Scale to 100%.

Now I’ll institute an expression for the gradient’s Spread. Here I’ve simply used the quantity of each rep’s orders.

And now you have it. The column’s background gradient now has the column emulate a bar chart giving the user proportionate data visualization…with zero scripting!