K2 blackpearl development

I am chiefly a K2 blackpearl Workflow technologies developer, certified in K2 blackpearl Core, K2 SmartForms, and K2 blackpearl Extensions technologies.

See project history details and my interactive resume for more about how I've used K2 blackpearl.

I maintain a blog called START RULEwhich serves as a resource for others working in K2 blackpearl technologies. Recent posts are listed below:

Implement the Excel Export Control on a SmartForms List View

My client was looking for a way to export a list produced by a report engine to a Microsoft Excel® spreadsheet file (.xlsx). Other applications in the company have made use of an Excel Export control, so I thought I’d better figure the thing out. As far as clues on how to configure the control, […]

Microsoft Ending IE10 Support in 2020

According to a Computerworld article published 1/31/2019, Microsoft has opted to end support for Internet Explorer version 10 (IE10) next January. Microsoft had originally expected to support the browser until the sundown of Windows Server 2012, scheduled for October 10, 2023, but it is now ending IE10 support over three and a half years earlier […]

Error: “There is no such object on the server”

This was a really weird one. A client’s application suddenly suffered from this error in all environments simultaneously. The root cause had nothing at all to do with K2 blackpearl, but it affected the service keys of the instance of a service, which brought down the service and caused the exception. Symptoms Error prompt reading […]

Build a Reporting Engine Using K2 SmartForms: The Interface

This post is the sixth and final installment in the Build a Reporting Engine Using K2 SmartForms series. In previous posts, I talked about some aspects of the T-SQL used to support the engine, and touched time and again on how the actual job of the interface is to build a SQL WHERE clause to […]

Prepare to Upgrade Your K2 SmartForms Applications

My client has an older version of K2 blackpearl/K2 SmartForms, and is preparing to upgrade to the latest minor upgrade in version 4. Here are my tips for upgrade prep. I strongly recommend you go through each of your SmartForms applications to do the following: delete disabled rules. These are named groups of event-driven conditions […]

Build a Reporting Engine Using K2 SmartForms: SQL, Part III

This post is the fifth installment in the Build a Reporting Engine Using K2 SmartForms series.   In the previous post I shared some thoughts about database functions that would make life easier when building your reporting engine. In this post, I thought I would wrap up the data layer discussion with a word or […]

Build a Reporting Engine Using K2 SmartForms: SQL, Part II

This post is the fourth installment in the Build a Reporting Engine Using K2 SmartForms series.   In the previous post I shared some information you might consider when designing your data source and some of the database objects that will directly support the reporting engine — specifically, tables and views. In this installment I […]

Build a Reporting Engine Using K2 SmartForms: SQL, Part I

This post is the third installment in the Build a Reporting Engine Using K2 SmartForms series.   Through reading the previous related posts, you should understand that the secret sauce to this whole engine is the generation of a WHERE clause that gets matched to a SELECT statement to form a T-SQL query. So I […]

Build a Reporting Engine using K2 SmartForms: Concept

This post is the second installment in the Build a Reporting Engine Using K2 SmartForms series.   The concept behind the reporting engine is simple: put the querying power of Transact-SQL (T-SQL) into the hands of business users through a simplified and intuitive interface. That’s really all there is to it. All the terminology I […]

Build a Reporting Engine using K2 SmartForms: Introduction and Terminology

I can’t recall the last time I’d been this excited about building a new feature. My client has a high-touch, high-visibility application — and I mean “high-touch” more in the sense that a lot of people use it, rather than it gets used often (quantity as opposed to duration, I guess). At the top of […]

(older entries)