Results 1 to 2 of 2
Like Tree1Likes
  • 1 Post By kir

Thread: zuckerreports show blank report result on reports with non-englsh characters in query

  1. #1
    rodnikosh Guest

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

    I installed and using zuckerreport 2.0 in sugarcrm 6.5.5 with a much success.
    i create my reports in Ireport 4.8.0 and run them in zuckerreports and everything works fine.

    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 (reuturn 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 Is in the query.

    Any tip will help, i'm totally stuck...

  2. #2
    kir
    kir is offline Sugar Community Member
    Join Date
    Nov 2011
    Posts
    702

    Default Re: zuckerreports show blank report result on reports with non-englsh characters in q

    Quote Originally Posted by rodnikosh View Post
    I installed and using zuckerreport 2.0 in sugarcrm 6.5.5 with a much success.


    when running this report on zuckerreport i get a blank report in any situation where Hebrew Is in the query.

    Any tip will help, i'm totally stuck...
    Make sure that when you type your query in browser for zuckerreport - browser is setted to utf8 without cherset recognition. Don't do it by copy-paste. Not sure, but it might help (i hope)

    kir
    rodnikosh likes this.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help storing query result
    By japtone in forum Developer Help
    Replies: 12
    Last Post: 2011-03-23, 10:43 PM
  2. How to show total result
    By chaptergoat in forum Developer Help
    Replies: 4
    Last Post: 2010-03-18, 03:00 PM
  3. Report - Show Query 5.0
    By gkornacki in forum Help
    Replies: 1
    Last Post: 2009-03-12, 03:12 PM
  4. Report show rubblish characters for chinese
    By adrianmak in forum Help
    Replies: 0
    Last Post: 2006-11-13, 08:57 AM
  5. Replies: 1
    Last Post: 2006-08-03, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •