Trying to get my report to sort on column headings in a report.
Can make it happen normally, but, the difference here is it is coming from a Stored procedure and the columns can be different each time.
They are dates and the report shows 6 periods - and always just the 6 periods - but period 1 might be a week this time and a month the next time.
The headings change according to the data coming down, but the matrix will not sort when I click on the column header.
I have ticked "Enable interactive sort" Sort: group: "Period". Sort by: "Period".
This gives me a warning: "The Text Box "Period" is defined at the scope "Period", which is identical to the scope used as SortExpressionScope. This interactive sort has no effect at runtime, since it sorts only the particular instance itself."