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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 intrest error

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 field
Fields!bookvalue.Value = Book Value

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-20 : 21:51:50
In which tool?
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -