I have a data query that returns data in the following format:
Name Period Value
-----------------------------
Bob Jan 123
Bob Feb 456
Bob Mar 789
Tom Jan 321
Tom Feb 654
Tom Mar 987
Joe Jan 147
Joe Feb 258
Joe Mar 369
The different periods are constant between names, but will be different between executions of the report (ie, I may query a report on Jan/Feb/Mar now, or Apr/May/Jun later). I'm trying to put that into a table in my Reporting Services report, that would look something like this:
Name Jan Feb Mar
----------------------------
Bob 123 456 789
Tom 321 654 987
Joe 147 258 369
Can anyone point me to an example of doing something like that? I'm not even sure how to describe that 'rotation'(?) of the data. The columns should be dynamic based on what Period values are in the dataset.