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 |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2011-04-13 : 17:15:30
|
| I have 2 datasets:the first one containing the monthly sales for my customers for this year and the second one containing the monthly sales form my customers for the previous year.I've set up a matrix reports that groups the rows by customer and the columns my month of the year. I would like to set up my report so that the current years monthly sales per customer are in the first row and the previous year monthly sales for that customer are in the second row.Anybody can point me into the right direction? |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-14 : 09:23:03
|
| I would say that you should handle that on the SQL side by returning 1 resultset that structures it the way you are asking. I am not sure that the matrix control will do what you want.Hey, it compiles. |
 |
|
|
|
|
|
combine 2 data sets in one report