robidomadenik Posted July 27, 2011 Share Posted July 27, 2011 Hello. I'm using JasperSoft iReport Designer 4.0.1 and I'm having trouble calling mySQL function from Report Query window.I made this function in mySQL (SQL Manager 2005 for mySQL) and function works fine. But when I want to use it like this from Report Query window in iReport Designer: SELECT datum, SPLIT_CONCAT('test','.')FROM sk_2007_sak_programi WHERE konto like '120% ....it doesn' work at all.' It says: "SQL problems: FUNCTION razvoj_programi.SPLIT_CONCAT does not exist"I used query language SQL or PLSQL, tried both and the same error. Please...anybody?? Thanks, RobiCode:SELECT datum, SPLIT_CONCAT('test','.')FROM sk_2007_sak_programiWHERE konto like '120% Link to comment Share on other sites More sharing options...
despec Posted July 29, 2011 Share Posted July 29, 2011 I can't be 100% certain, but I don't believe MySQL has such a function called "SPLIT_CONCAT"...I believe that's why you're getting the error. David Link to comment Share on other sites More sharing options...
robidomadenik Posted August 1, 2011 Author Share Posted August 1, 2011 Hello. As I said...this is MY custom made function :-)Anyway doesn't matter anymore....I found another way solving my problem.Thanks,Robi Link to comment Share on other sites More sharing options...
ruudheemskerk Posted March 29, 2012 Share Posted March 29, 2012 Robi, How did you solve this?Regards Ruud Link to comment Share on other sites More sharing options...
vinayt Posted September 9, 2014 Share Posted September 9, 2014 Hi Robi, How did you solve this problem. Am in the similar situation. Thanks, Vinay Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now