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 |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-09-04 : 10:58:43
|
| I have a report that displays the number of calls per customer service rep by department.The SQL is:Select Dept, EmpName, YYMM, 'Counter' AS 'Counter' Where (Date >= @StartDate) and (Date < @EndDate +1) and (Dept IN (@Dept))The Column is YYMM and the Rows are Dept and EmpName. The Detail is Counter and is defined as =Count(Fields!Counter.Value)The user also selects the Department from a stored procedure list (with multi-select) and the date range.What the users are looking for is the Dept field to repeat on every row (like a tabular) because some departments are large and span multiple pages.I have the group check box checked to keep header rows when scrolling but that does not help when printing or exporting to excel which are the 2 most common options used. I much prefer the Matrix report option because some managers measure and report on yearly, some only 6 months and some only for last 2 months. It would save me the evils of trying to code this as Tabular.Your help is greatly appreciated - JohnJohn"The smoke monster is just the Others doing barbecue" |
|
|
|
|
|
Matrix Functionality but Look of Tabular on Rows