Create an ORM Database for your K2 SmartForms Objects

I think it’s fair to say that most of us in this industry at least started out taking over someone else’s project. The original developer left long before you got there, leaving you to figure out what’s what.

Some of us are still in that position, or find ourselves back in that position at some point. So if you can take the time to inventory all of your SmartForms objects at the start, you can let your shiny new object relational management (ORM) database do a lot of your grunt work for you later on.

Continue reading “Create an ORM Database for your K2 SmartForms Objects”

Create an ORM Database for your K2 SmartForms Objects

Implement the Excel Export Control on a SmartForms List View

My client was looking for a way to export a list produced by a reporting 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.

Continue reading “Implement the Excel Export Control on a SmartForms List View”

Implement the Excel Export Control on a SmartForms List View

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 append to a SELECT statement and execute to return data to a list.

Today I’ll talk a bit about the interface.

Continue reading “Build a Reporting Engine Using K2 SmartForms: The Interface”

Build a Reporting Engine Using K2 SmartForms: The Interface

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.

Continue reading “Build a Reporting Engine using K2 SmartForms: Concept”

Build a Reporting Engine using K2 SmartForms: Concept

Fake a Header on a SmartForm by Setting Label Control Widths

Somehow you find yourself in the awkward position of having to create a header on one control above your content, which is in a another, separate control. My current example is content laid out in a series of views, and having to fake a header on the form. How do I get the faux “columns” to match up?

Continue reading “Fake a Header on a SmartForm by Setting Label Control Widths”

Fake a Header on a SmartForm by Setting Label Control Widths