Tech Articles


Dynamic Runtime DataWindow Group Creation


Here’s a DataWindow tip…and a half.

Unless you want to dynamically build a DataWindow object from scratch at runtime (it’s do-able…but quite involved), there’s no direct way to create a group for a DataWindow object in an ad hoc manner. Here’s a workaround.

First, insert a computed field in an extant DataWindow object and give it an expression that’s an empty string. For the sake of this tip the computed field’s name will be “dynamicgroup”.

image

 

 

 

 

 

 

 

 

Then create a group based on this computed field.

Image

 

 

 

 

 

 

 

 

 

 

image

 

 

 

 

 

 

 

Format the DataWindow object according to your needs and save.

Now at runtime, modify the computed field’s expression to have the value of the column name by which you wish to group the result set.

dw_employees.setredraw( FALSE )

dw_employees.Modify(“dynamicgroup.Expression='” + as_coltogroup + “‘” )

dw_employees.setsort( as_coltogroup + ” A”)

dw_employees.sort( )

dw_employees.groupcalc( )

dw_employees.setredraw( TRUE )

After calling SetSort() and Sort() to sort by the column on which you’re grouping, don’t forget to call GroupCalc() to recalculate the breaks in the groupings.

Certainly this technique may be adapted to implement more than one grouping level. For those of you who maintain and enhance frameworks, the sample code fragment can certainly be made more generic as far as the reference to the DataWindow control and to the name of the computed field(s).

OK, here’s the half (.5) tip.

You’ve defaulted the value of the computed field’s expression to an empty string. This will work fine for grouping on columns of type string. However, for columns of other data types, you’ll need to invoke the DataWindow expression function String() to convert the non-string columns’ values to strings in order for the runtime modification to have the desired effect. Here’s how the accommodation appears in the sample code from earlier in this tip…

dw_employees.Modify(“dynamicgroup.Expression=’String(” + as_coltogroup + “)'” )

Comments (0)
There are no comments posted here yet

Find Articles by Tag

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