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 : 10:35:06
|
| 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. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-09-11 : 16:20:48
|
| This isn't the SSRS forum.An infinite universe is the ultimate cartesian product. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-13 : 13:45:09
|
| can we see expression that you used? also what are column and row groups applied? |
|
|
|
|
|
|
Difficult Report