SQL dashboard report: Select table column dynamically
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2023 01:13 PM
I am using SQL Dashboard report, there are around 400 columns in a table, I want to display some of the columns based on data, not all 400 columns should be displayed.
eg: a table have column named c1, c2,c3,c4 and rows r1, r2, r3, r4. The report should show columns as per the below scenario,
case 1: for row r1, the report should dynamically show c1 and c2.
case 2: for row r2, the report should dynamically show c3 and c4.
case 3: for row r3, the report should dynamically show c1 and c4.
Note: consider the report is showing only one row for now.
Labels:
- Labels:
-
SQL
-
SQL Dashboard