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 |
|
santu
Starting Member
3 Posts |
 Posted - 2010-06-01 : 17:51:45
|
| Hi,I have one report with the matrix. I want to see the detailed data if we click on the each row of the report. For example here I have different statuses like completed, new etc.. If I clik on New I have to all the new items created.My matrix is like below May JuneNew 1327 689Completed 2000 1500Late 1000 500If we clikc on the new I have to see all the records in may and june. Can you please tell me the answer as soon as possbile. I will aprreciate your help.Thanks in advance,Santhoshi |
|
|
tking1
Starting Member
22 Posts |
Posted - 2010-06-02 : 09:47:46
|
| Add the detail data as a row group to your matrix, then right click on the data field for the detail group and go to properties/visibility. Select hidden, then check box that says allow to be toggled by another report item.Here's a URL to more details.http://www.mssqltips.com/tip.asp?tip=1329 |
 |
|
|
santu
Starting Member
3 Posts |
Posted - 2010-06-03 : 10:44:48
|
| Thank you. |
|
|
|
|
|
|
Matrix drill down