zishanali

ok i figured it out the problem was i changed the theme as jasperadmin and it is for a specific organization rather if we changed the theme as superuser than the it will get reflected on the complete theme whether the user is logged in or out. just remember to login from superuser and password as superuser. create the new theme, upload it and set as active. note : while uploading the theme do not zip the file from folder name rather go inside the folder and select all files and send to zip. themes work this way other wise it will create a new folder when you upload any theme, you will save your time i spent 3 hours figuring this out zk Post Edited by zishanali at 09/06/2012 14:38

any help community zk

can any one suggest how to change the logo on the welcome page (ie login page) of the jasper server professional 4.7, I can successfully change the logo after login as I know the process, simply update cutom_override.css in your theme and you are good to go but, logo only changes after login before login it is showing the same jasper logo, dont know why. check the attachment. any reply is appreciated.

Hi, did you solved it, I am getting the same error. let me know please. regards zk

Hi Ankush, sorry, i am using postgresql and ireport, I am new to functions as well as ireport. i will tell yu what I want to achieve, I created a function in postgresql by the name show_names(ref refcursor), here is the code ----------------------------------------------- create or replace function show_names(ref refcursor) returns refcursor as $$ begin open ref for select id,name from oba_emp; return ref; end; $$ language plpgsql; -------------------------------------------------------- now, i have to call this function in ireport - what I did to test the bare bones, In a brand new ireport, I opened the Report Query and type below: -------------------------------------------------- select show_names('you'); fetch all from you ---------------------------------------------- when I am pressing the button Read Fields it's giving the error: Multiple Resultsets returned by the query. I dont know how to handle multiple resultset in ireport. or may be I am writing the query wrong. to sum up: I have to call function's of postgresql in ireport and roaming in the dark. reg. zk

plz help any one zk

Hi, {call show_names($P{sptest})} calling the above stored procedure in report query but getting the following error. Error:SQL PROBLEMS: ERROR: Syntax error at or near "{" dont know what is the problem. below is my stored procedure which i am calling create or replace function show_names(ref refcursor) returns refcursor as $$ begin open ref for select id,name,address from oba_emp; return ref; end; $$ language plpgsql; find attached the snip for help. above stored procedure is working fine in pgadmin but not when I am calling using ireport. any help is appreciated. zk