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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-05-20 : 12:37:40
|
| HiI 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 fieldThe expression field has the following value: =Fields!Calldate.ValueThe operatordrop down has the value: TOP NThe 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? |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-05-20 : 13:32:22
|
| smalldatetime |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
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. |
|
|
|
|
|
|
"Failed to evaluate the filter value"