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

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