In a cross-tab query, I want to hardcode the column names in the properties. But I want only those columns that contain data to show up when queried.
Can I somehow put and IIF statement inside the PIVOT command?
Something like:
if a column containes data based on my query pivot on that column
Is that possible?
Can I somehow put and IIF statement inside the PIVOT command?
Something like:
if a column containes data based on my query pivot on that column
Is that possible?
