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
 "Failed to evaluate the filter value"

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-20 : 12:37:40
Hi
I an tring to use the filter tab on my table properties to select the TOP N (where N = 5) rows based on dates.
Calldate is a date field

The expression field has the following value: =Fields!Calldate.Value
The operatordrop down has the value: TOP N
The Value field has the value: 5

"an error occurred during local report processing.
an error has occurred during report processing.
Failed to evaulate the FilterValue."

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-20 : 13:17:08
whats the datatype of calldate?
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-20 : 13:32:22
smalldatetime
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-20 : 14:05:27
can you try using a parameter instead and pass the value through it?

http://jessicammoss.blogspot.com/2008/08/display-top-n-rows.html
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2009-05-20 : 17:13:09
Thanks that worked.
I don't know why it didn't work the other way though.

Cheers.
Go to Top of Page
   

- Advertisement -