Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asms
Starting Member
1 Post |
 Posted - 2005-08-31 : 01:39:37
|
| Hi..I am facing a problem with the SQL reporting Service and also am pretty much new to the reporting service…I need to create a yearly report from a table called say tblData. It has rows like [items] [Amount] [Date].Item1 100 05/2005Item1 110 06/2005Item2 200 05/2005Item2 230 06/2005Now I want the report like [Items] [First month] [Second month] etc...The data for the first month, second month etc will be the [amount] for that month.ie the report rows should be like[item] [05/2005] [06/2005]item 1 100 110 item 2 200 230 In the report the month columns will be dynamic according to the data in the tblData table...Now how should I implement this?First I though of writing up a Stored Procedure so that the sp returns the formatted data (i.e. a returning a table having the having the dynamic columns). But how can I create the report using these dynamic columns in the reporting service?Thanks in advance for the replies…ASMS |
|
|
fireloard
Starting Member
23 Posts |
Posted - 2005-08-31 : 06:54:12
|
| I asked a question pretty similar to this just the other day. I used a stored procedure to sum up the columns I needed. You could use a union but I just went with the case for each month I needed... here is the link..http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53833 |
 |
|
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-08-31 : 12:24:32
|
| You have to use a matrix and group by the date for the columns. I think this will work for you. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
|
|
|
Reports using Dynamic Columns