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 |
|
foxprorawks
Starting Member
17 Posts |
 Posted - 2009-09-11 : 16:45:53
|
| I need to produce a Training Matrix Report with columns showing the Course Name and rows showing the names of the Personnel who will complete the courses.The intersection of the two will show coloured cells depending on whether the course has been completed or is overdue.I've tried creating a report using a matrix in SSRS 2005, but I can't get it to work because SSRS says: "The BackgroundColor expression for the textbox ‘dateValue’ references a field outside an aggregate function. Value expressions in matrix cells should be aggregates, to allow for subtotaling." Even if I try to print the date inside the cell, it doesn't display.I can't think of a way of using an aggregate value for the date.Is there another way of doing this in SSRS? The possible number of courses is unlimited - is it possible to create a report containing a table and programmatically expand the number of columns in the table?Regards.Matt. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-15 : 08:56:20
|
| For the aggregate function you can use FIRST. as in (=First(Fields!CalcDate.Value)John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Difficult Report