expressions in layout view of Reporting Services

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

expressions in layout view of Reporting Services

Author

Topic

jewelfire
Starting Member

4 Posts

Posted - 2006-10-31 : 20:04:42

Using MS Visual Studio / Reporting Services

Table = calllog

Field 1 = RecvdDate Field 2=RecvdTime

in my layout view I have combined these two - Txt header CallRecvd (Value=Fields!RecvdDate.Value & " " & Fields!RecvdTime.Value)

I have a txt box called [Today] Value =Today() (I am showing this in a box but it actually doesn't have to show at all

last txt box - I need to do the following

=DateDiff([CallRecvd],[Today])

error is CallRecvd is not declared

or even if I ignored the time value and did this
=DATEDIFF("d", NOW(),[Fields!RecvdDate.Value])
error is Bracketed Identifier is missing??

any help to put me on right track appreciated

Jewel

Will Riley
Starting Member

10 Posts

Posted - 2006-11-03 : 05:43:48

try

=DATEDIFF("d", Today ,Fields!RecvdDate.Value)

i.e. Do not use the []

Cheers,

Will

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources