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

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