[Solved] Error while adding SQL server function to the report

[pravin.cognos]

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

[HalfBloodPrince]

Try this DATEADD({YEAR}, -1, Start date)

[pravin.cognos]

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

[blom0344]

What connectivity did you define for the datasource?  OLE/DB or ODBC ?

[pravin.cognos]

We use OLE/DB connection.

[blom0344]

Actions --> Package --> Specify Package Function List..

Are SQL server functions in the selected list?

[pravin.cognos]

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