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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2010-06-04 : 10:26:54
|
| Hi,I am using SSRS 2005.I have a matrix report with a series of drugs across the top horizontally. I have series of diseases vertically down the report. In the detail, I have a percentage that is calculated. This all works. Here is what the report looks like: Aspirin Penicillin Tylenol Flu 3 6 12Cold 4 2 9Pneumonia 2 5 15Malaria 4 3 8But I want to add a column that displays vertically down the page just to the right of the diseases and to the left of the first detail. This column will contain a count of all diseases. So I now want my report to look like this: Total Aspirin Penicillin Tylenol Flu 10 3 6 12Cold 6 4 2 9Pneumonia 11 2 5 15Malaria 2 4 3 8Presently, my matrix report does not have the Total column. This is what I want to add to my matrix report. The Total column is the count of each disease. But I think I need another dataset to calculate this value since it really is different then the detail I am presently building. Is it possible to calculate this value in another query and then have it display next to each disease in my matrix report? Can anyone help me with this? Thanks,Bob |
|
|
|
|
|
Add a new column to an existing matrix report