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
 Colouring empty/missing cells in matrix - RS2000

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 2000

Basic data model, and how it should look in the matrix:
Field
|
v
Item --> Value

The 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 value
So, 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
   

- Advertisement -