Error evaluating expression

Hot Topic

Rendered html report has incorrect hyperlink url
SORTS: Change the temp sort file
BOL Package example Errors
what is [SQL-DMO]
SQL Server authentication mode in 'Transfer SQL Server Objects Task' gives error
Where is the Northwind SQL scripts for SQL server 2005
[Transfer SQL Server Objects Task] Error: Table "XXXXXXX" does not exist at the source.
Server Status
New Guy Question 2: SQL on-the-fly at package runtime?
Cluster Node not running all databases

SQL Server

SQL Server 2005 Express on VISTA
Unable to use Reporting Services
Beta testing SP1
SQL 2005 Report Site Permissions
Management Studio all databases . . .
Report Builder Processing Error
connecting using "datasource=localhost"
create user only with permissions, to select, insert, update, delete, and exec sps
adding web reference to ReportExecution2005.asmx
Performance & Threading

Error evaluating expression

Greetings my SQL friends.

Why do I get an error message saying that the following expression won't evaluate

"Select * from Price_grp where price_grp_id >= " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] +
" and " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] + " > 0"

Thanks for your help in advance.




Answer this question

Error evaluating expression

  • Renee Rinker

    Hi friends,

    I have solved the problem now. I didn't change the code but I got it to evaluate in the end. I don't know what I did to fix it but perhaps there was some issue with the spaces. I don't know...



  • Whisky Fudge

    Do you still have a note of the error message you had when it would not evaluate

    Donald



  • Paula

    Afraid not. Like I said, not quite sure how I sorted it out but I reckon there was some issue with white spaces or something because the same expression worked without any changes!

    Thanks.



  • Error evaluating expression
Answer this question