Forum Discussion
How to make the Reports dynamic ?
Hi Anonymous ,
do you need the new columns? If not, then there is a command: RemoveOtherColumns that let you keep just the columns you need.
If you need the columns, you should probably do a "unpivot other columns"-operation, as the structure of your data source doesn't let you use the column names as identifiers.
Community ChampionIt's tough when they change the underlying data on you. This is going to depend heavily on what you are doing in your query and where they are adding columns (to the end, in the middle?) ImkeF might have some best practices on how to handle this sort of thing.
- ImkeF
Hi Anonymous ,
do you need the new columns? If not, then there is a command: RemoveOtherColumns that let you keep just the columns you need.
If you need the columns, you should probably do a "unpivot other columns"-operation, as the structure of your data source doesn't let you use the column names as identifiers.