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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2010-12-15 : 16:30:17
|
I have created a matrix report (see image1)I have grouped on Userid and Appt_ref (rows) and by date (columns) as you will see on the image.My problem is that each appt is appearing on a separate row. I can understand why it is happening but I would like to hide the Appt_ref grouping (the dark grouping next to the userid)and somehow make the appts appear from the top row on each day.(see image 2 for the desired result)e.g.  |
|
|
|
|
|
Need help with Matrix report