Posted 9 September 2017, 8:29 am ESTLook here for pictures: http://stackoverflow.com/questions/13149573/how-to-dynamically-pivot-non-numerical-data
Is it possible to display a field as "Values" either without any sort of aggregate operation, or using max instead? Perhaps this is against the nature of the beast or I'd have found it already - however it feels like a generic pivot viewer that can dynamically pivot non-numerical data using max (as I can with SQL) is very much needed.
I've been looking into various ways to do it, and I know I can perform a pivot on the SQL side within a view, to load in LightSwitch, but the problem is this can't be done with dynamic columns without writing dynamic SQL (regardless of whether you use PIVOT or SELECT CASE), and if you use dynamic SQL that means you have to recreate the view when the data used for those columns changes. I don't want to have to recreate the view when new data (pivoted to columns) is added.
I'm also using WCF RIA Services to denormalize data in my database for a grid/OLAP to display whatever, and it's excellent, but being unable to display a date in the manner I want with the OLAP control is a little annoying (I can of course have it as a row/column field, but I don't want that, I want to see a date for each combination of row&column, just as "Values" are). Anyone have an idea on how to do this, or when/if ComponentOne's OLAP control will add the ability to use max() in such a fashion?