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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-09-24 : 06:22:54
|
| Hi,Im trying to write an expression in the border style properties, i followed the help files and it guided me to this which should work:=IIF(Previous(Fields!Product)=Fields!Product, "Dotted", "Solid")But I get an error from reporting services saying it is not supported, any ideas?Thanks |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-24 : 08:09:52
|
| Are you getting:[rsCompilerErrorInExpression] The BorderStyle expression for the textbox ‘textbox7’ contains an error: [BC30452] Operator '=' is not defined for types 'Object' and 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field'.? I have tried every possible combination without success...John"The smoke monster is just the Others doing barbecue" |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-24 : 08:37:11
|
Yea same error, so i just created values for each record in the matrix and didiif(Fields!Record.Value = '1', "Dotted", "Solid")Its abit silly cant just lay a standard rule/formula and the matrix layout sets up itself.quote:
Originally posted by JCirocco
Are you getting:[rsCompilerErrorInExpression] The BorderStyle expression for the textbox ‘textbox7’ contains an error: [BC30452] Operator '=' is not defined for types 'Object' and 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field'.? I have tried every possible combination without success...John"The smoke monster is just the Others doing barbecue"
|
|
|
|
|
|
|
Border style