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.

All Forums  Development Tools  Reporting Services Development  Matrix - hide some columns?

Author  Topic  Fletch Starting Member 29 Posts Posted - 2006-11-15 : 09:47:34 Hi, I'm using a matrix with seven rows (one for each day of the week), and 3+ columns. The first column contains the day, the last column a subtotal. Between the two are 1+ columns containing values per outlet. My problem is that when there are more than 2 outlets, I run out of screen space (I'm developing a report for use on a mobile/PDA). Is there a method of hiding/unhiding all but 2 outlets? I think the perfect solution would; a) If outlets <=2, show everything. b) If outlets >2, show 2 outlets at a time with a scroll type feature (keeping the date column and subtotal column visible). Many thanks for any pointers....