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 |
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-05-20 : 10:43:08
|
here is the error code that comes up when I try and place this line of code in under the layout tab.Is not defined for types ‘object’ and ‘System.TimeSpan’=Switch(Fields!eqprecdt.Value< CDate("1 Jan 2007"),Fields!bookvalue.Value*(Now() - CDate("1 Jan 2007"))* .07/365,Fields!eqprecdt.Value> CDate("1 Jan 2007"), Fields!bookvalue.Value *(Now() - (Fields!eqprecdt.Value))* .07/365)Fields!eqprecdt.Value = ACQ Date this is already a date fieldFields!bookvalue.Value = Book Value |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:51:50
|
In which tool? |
 |
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-05-21 : 08:19:44
|
Microsoft Visual Studio. It has 3 tabs, data, layout (The one I am talking about), and Preview |
 |
|
|
|
|