Jump to content
We've recently updated our Privacy Statement, available here ×

blank report result on reports with non-englsh characters in query


rodnikosh

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...