I have a query that is a pivot table. Not only will the column numbers vary but the name of the columns will change to. This query will not always produce a result with same number of columns.
What i want to do is just produce a report that is a "select * from pivot query" that will support multiple columns for diffrent runs of the query.
Is this possible?
I think to achieve this you would have to use a matrix instead of a table.
No comments:
Post a Comment