Dear Gurus
Our database is Sql Server 2005. We created relational models. While building packages, I have selected SQLServer in the function list. But I am facing two problems while authoring the reports.
1. I dont see SQLSever in "Vendor Specific Functions" tab in the expression editor.
2. When I add any SQL server function to the report, it is throwing an error.
Ex: I added a date function i.e DATEADD(YEAR, -1, Start date) and when validated got the below error.
Error: QE-DEF-0459 CCL Exception. QE-DEF-0260 Parsing Error before or near ......
Please help !!
Thanks
Praveen
Try this DATEADD({YEAR}, -1, Start date)
Hey Thanks Prince
The Flowers braces worked. May I know what is the reason I am not seeing the SQLServer function set and why should we use this braces in the expression.
Cheers
Pravin
What connectivity did you define for the datasource? OLE/DB or ODBC ?
We use OLE/DB connection.
Actions --> Package --> Specify Package Function List..
Are SQL server functions in the selected list?
Thanks a lot Blom :)
There was the error. I selected SQLServer and moved it to other window by misatake. Now I moved it to Selected functions window from Actions tab. Thanks for your help.
Cheers
Praveen