rodnikosh Posted January 1, 2013 Share Posted January 1, 2013 i create my reports in Ireport 4.8.0 and run them in zuckerreports and everything works fine (zuckerreport is like jasper server but for using in SugarCRM). Everything works fine and the ireport jrxml files presented great in zuckerreport , just like it does in Jasper Server.But when trying to make zuckerreport execute a report with Hebrew language characters (UTF-8) , I get a blank report. For example, a report i created with this simple query show a blank report (0 results) on zuckerreport although it runs great (return results) in Ireport and mySQL database: SELECT COUNT(leads.`lead_source`) AS Count_of_sources, leads.`primary_address_city` AS leads_primary_address_city, leads.`lead_source` AS leads_lead_source FROM `leads` leads WHERE primary_address_city = “תל אביב” and Deleted=0 GROUP BY leads_lead_source when running this report on zuckerreport i get a blank report in any situation where Hebrew characters (UTF-8) are in the query. Any idea will help, i'm totally stuck... 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