Cross-Tab

My apologies, as I am not familiar with cross-tab, but I assume you are referring to this concept below:

https://support.office.com/en-us/article/Make-summary-data-easier-to-read-by-using-a-crosstab-query-8465b89c-2ff2-4cc8-ba60-2cd8484667e8

https://www.red-gate.com/simple-talk/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/

If so, perhaps one can use a SQL stored procedure/view to create this crosstab (with SELECT, GROUP BY, etc.).  Then surface these stored procedures/views as a SmartObject using the SQL Server broker:

http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.7/default.htm#ServiceBrokers/SQLServer/SQL_Server_Service.htm?Highlight="stored%20procedures"