Skip to main content
Nintex Community Menu Bar

is there a way to generate a cross-tab view from either data in an SQL table or a SharePoint List?

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"

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings