Is it possible to call procedure and function in BIRT?

I am creating a report with SQL server as database and When I use the functions like RANK() or custom functions it says wrong SQL Syntax? Can you tell me whether I can use functions and procedure directly from BIRT?

Find more posts tagged with

Comments

saravanam

In BIRT SQL query builder I couldn't use the SQL server 2005 built in functions like DATEDIFF(), LEFT(), RIGHT(), etc., Can you please let me know whether BIRT support these functions or not? Also is it possible to call procedure from BIRT?

JasonW

This should be possible. I just created a funciton in MySQL (not SQL Server) and called it like:
select testFunction(?);

Jason

saravanam

Hi Jason,

Thanks for your reply. I too tried for the MySql functions and it is working without any issues. But when I use the SQL server data source and use the built in function like below

SELECT LEFT('ABCDEFGH', 2) it is not working and says an error message like "SQL syntax is wrong or is not currently supported. Some SQL builder functions have been disabled. To enable these functions change the syntax."

-Saravanan

JasonW

Can you log a bug for this?

saravanam

I have logged a bug and the bug id is 300471.

Saravanan

JasonW

Thanks for logging it.

saravanam

Hi Jason,

We have changed the sql driver jar file from sqljdbc.jar to jtds.jar and now everything works fine. Looks like a driver issue.

-Saravanan

JasonW

This is good to hear(read).