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 |
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-17 : 06:31:03
|
I have a report with a tablix in which I set the colour of calculated textbox using the expression=iif(me.value<0,"Red","Black")This works fine if there is no page header.Works fine if there is static data in the page header.As soon as a variable is referenced in the page header (parameters, total pages, page number) then it gives an error in the colour setting expression.Object reference not set to an instance of an objectAnyone know how to get round this or whether it is a bug?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-17 : 11:19:32
|
try replacing the me.value with actual expression given in the cell |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-20 : 04:49:31
|
Thanks but the idea is that I don't want to do that - have a lot of cells and just want to copy the formatting without changing it.Had a response in another forum to check that sp1 is installed and it isn't so I'm going to get them to do that and see if it fixes the bug.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 09:14:25
|
Still seems to happen with sp1. I've raised a bug report.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 20:13:17
|
It is a bug and will be fixed in the next major release of reporting services (whatever that means).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|