Tech Articles


Data-Driven Column Gradient Bar


As of PowerBuilder 11.5, DataWindow columns have been able to 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.

DataWindow Painter - Computed Field

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.

Computed Field's Background Properties

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

Spread property of column background gradient

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

Spread property value of the gradient

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!

Data visualization of percentages using a gradient is achieved

Comments (0)
There are no comments posted here yet

Find Articles by Tag

Database UI Modernization Application Encoding Event Handler Windows OS .NET Std Framework Script Database Painter API SqlExecutor BLOB Jenkins PowerServer Web Transaction Import JSON RibbonBar SQL OAuth 2.0 Stored Procedure RibbonBar Builder PDF Android Menu Database Table Data InfoMaker PBNI Messagging Charts Export GhostScript Interface Design DragDrop .NET Assembly ActiveX Platform DataWindow JSON Branch & Merge Authentication SVN Trial Elevate Conference Azure Data Mobile PowerBuilder Filter PostgreSQL ODBC driver Class Resize JSONParser Validation Installation TortoiseGit Database Table Schema CrypterObject DLL MessageBox DataType Service SnapObjects Icon ODBC C# OAuth SQL Server Encryption Sort HTTPClient PFC SqlModelMapper IDE Migration Window PowerServer Mobile Bug Windows 10 Icons REST PDFlib SDK Error RichTextEdit Control PowerScript (PS) Export JSON Excel Outlook UI Performance Web Service Proxy Database Connection TreeView PowerBuilder Compiler Authorization NativePDF Event Handling SOAP Source Control Git OLE Array Debugger Database Profile WebBrowser Model CI/CD Linux OS Database Object SnapDevelop Expression Testing TLS/SSL 32-bit PBVM UI Themes Variable Oracle Debug PowerBuilder (Appeon) JSON Database Table Automated Testing Source Code Import PostgreSQL 64-bit JSONGenerator License Event Repository Syntax iOS WinAPI Debugging File Graph COM CoderObject Open Source TFS Web API Visual Studio OrcaScript RESTClient DataWindow Deployment PBDOM DevOps Text XML External Functions Configuration .NET DataStore