Hi, is it possible to do the following change to a SQL Server 2005 Reporting Service report, required by a customer: say, I have a table with columns Name, Month, Number of Hits.
Name Month Hits
Joe Jan 5
Joe Feb 10
Each name has 10-20 months rows with numbers of hits for each month. The customer wants to have one row for each Name , followed by January, February (etc., dynamically created last 12 months), with numbers of hits as data:
Name Jan Feb March
Joe 5 10 25
How would I do that? Thanks.
Name Month Hits
Joe Jan 5
Joe Feb 10
Each name has 10-20 months rows with numbers of hits for each month. The customer wants to have one row for each Name , followed by January, February (etc., dynamically created last 12 months), with numbers of hits as data:
Name Jan Feb March
Joe 5 10 25
How would I do that? Thanks.