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 |
RS_Haasrode
Starting Member
1 Post |
Posted - 2006-10-17 : 05:06:38
|
Dear all,I would like to colour a cell in a matrix when it doesn't contain a value and another field is =1 (meaning that the value is mandatory).This is for Reporting Services 2000Basic data model, and how it should look in the matrix: Field | vItem --> ValueThe field contains a bit for mandatory.I have forced to show ALL fields and ALL items on the matrix, by initializing the database: (work-around because full outer joins on both field and item didn't seem to work)- For each field and at least one item in the shown group: empty record- For each item for one field I supplied one valueSo, now I would like to colour the cells which contain empty record or there is no record for the combination field/item and when field is mandatory.I appreciate any feedback, BR,Bert |
|
|
|
|