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

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... 

[add Combobox/list/dropdown parameter to Ireport report]

i solved the problem. it turns out zuckerreport is based on jasperreport server and therefore can add input controls too.

The solution is to create the "city_combobox" parameter as a string parameter and leave the query as is , like the above example i gave. thats it for the IReport.

in zuckerreport, add a parameter that its "Default Parameter Name" named city_combobox.

for a dropdown parameter choose a type of "user-defined Query" and fill the “Parameter Settings” and “User-Defined Query” fields with a query that will fill the dropdown with a list of values, for example:

SELECT DISTINCT
leads.primary_address_city AS leads_primary_address_city
FROM
leads leads

if you can't see the  “Parameter Settings” and “User-Defined Query” fields (in the new version of zuckerreport they are hidden), then

The code is needed to be added manually in the editview code of zuckerreport.
Add this code in modules/zr2_ReportParameter/metadata/editviewdefs.php :
5 =>
        array (
            0 => 'range_options',
  ),

then you'll see the hidden fields.

Create a new template using “jasperReports Template” on the menu, the template is actually the report:

a. Choose a name for the template and choose the jrxml file of the report (from local computer where the Ireport is).
b. Choose PDF.Excel and HTML.
c. Save
 

Create a new Parameter binding between the report and the parameter:
a. Push “Create”
b. The parameter name has to be the exact parameter name in the IReport.
c. Choose the report and the parameter and no need to choose “Bind to module”

Copy the .jasper file of the report into custom/zuckerreports2/resources in SugarCRM.
Go to “On demand reporting”, choose the report and the parameter is supposed to show.

There you go! :)

 

[add Combobox/list/dropdown parameter to Ireport report]

Thank you very much for all your help, i solved the problem. i didn't use the solution you gave but it helped me keep an open mind to find the right one.

as i said, i use zuckerreport component in SugarCRM to run the reports i create in Ireport. it turns out zuckerreport is actually "kind of" a jasperreport server!. all i needed to do is go deeper into learning zuckerreport and to find that it can add input controls too , just like jasperreport server. so i'm posting my solution as an answer. thank you.

[add Combobox/list/dropdown parameter to Ireport report]

sorry, but i can't create input controls at all using only the Ireport. as i said , i don't have the jasperreport server installed , only the Ireport. is there a way to do what you wrote in Ireport ? create input controls in Ireport?

[add Combobox/list/dropdown parameter to Ireport report]

thank you, but this causes the report to present a result that includes all the cities together. and also , where is the combobox that enables me to choose which city?.

when i preview ther report i get to insert a string. i don;t see any combobox with the city. what did i forget?

 

[add Combobox/list/dropdown parameter to Ireport report]

i want to enable the user to choose a parameter value from a Combobox / list / Dropdown / collection (whatever you choose),

and the value that he chooses will be inserted into the query.

i already created a string parameter that prompt when i preview the report and the string inserted into the query and it works great, but now i need to define a combobox.

 

i need to provide names of cities so my query is:

SELECT
     COUNT(leads.`status`) AS Number_Of_Status,
     leads.`status` AS leads_status,
     leads.`primary_address_city` AS leads_primary_address_city,
     leads.id AS lead_id
FROM
     `leads` leads
WHERE
     leads.`primary_address_city` = $P{city_combobox}
GROUP BY
     leads.`status`

i tried to make the city_combobox parameter a "Java.util.list" but i get "Parameter type not supported" error and also i don't know where to load the strings into it.

 

by the way, i don't know anything about Jasperreport server, i didn't install it, only Ireport is installed and up to know i did everything with it,

so i'm looking for a way to do that in Ireport only, without an intput control of jasperreport server.

it will be even enough for me to just provide the report with a manully inserted values into the combobox,

it doens't have to be even a query. for example, insert somewhere "NY","Miami", "Washington" into a list parameter,

but how and where do i do that?

[IReport “parameter Not Found” when adding a parameter]

Thank you,

There is much more detailed example here::http://isura777.blogspot.co.il/2011/10/pass-parameters-from-main-report-to.html

as you said, The parameters from inside the dataset , need to be mapped into the master report parameters. only then the master report recognizes the parameter defined inside the dataset.

[IReport “parameter Not Found” when adding a parameter]

i'm using IReport 4.8.0. i created a dataset and using it for a table and a chart and everything works fine.

now i want to add a string parameter so the user can insert a name of city.

so i added a new string parameter inside the dataset and dragged it into Page Header. i also updated the Dataset query so it will receive the value from the parameter:

SELECT COUNT(leads.`status`) AS Number_Of_Status, leads.`status` AS leads_status, leads.`primary_address_city` AS leads_primary_address_cityFROM `leads` leadsWHERE leads.`primary_address_city` = $P{city_to_choose}GROUP BY leads.`status`

but all i get when pushing the "preview" is "Parameter Not Found: city_to_choose" what did i miss?

 

[Jaspersoft Ireport doesn't support UTF-8 queries (Hebrew language)]

Solved it by defining a new database connection and this time with the following parameters:

jdbc:postgresql://IPAddress/DatabaseName?useUnicode=true&characterEncoding=UTF-8

From this point on, the report query started to return results.

[Special Slovenie character "�" in iReport's "Report Query window"]

WOW!! this actually worked! thanks!

To anyone who had problems with writing UTF-8 word (in my case hebrew language) in the "where" clause of a query in the Query editor and always got no results for the query although there are results. Create a new database connection with the following connection string: jdbc:mysql://IP/databaseName?useUnicode=true&characterEncoding=UTF-8

it solves the problem and the query starts to return results

[Jaspersoft Ireport doesn't support UTF-8 queries (Hebrew language)]

in Ireport 4.8.0 i need to write query with a "where" phrase that include a "UTF-8" word, like this:

SELECT accounts.name AS accounts_name, accounts.billing_address_city AS accounts_billing_address_city FROM accounts accounts WHERE accounts.name = "מיינפורם"

when i write it in Ireport, it doesn't find anything because it doesn't recognize the UTF-8 word in the where clause:

 

when the same exact query does work in the MySQL database:

 

 

So the problem is in the Ireport that deosn't recognize the UTF-8 word, how can i fix this?

 

[Java Heap space error when creating dataset]

on the iReport 4.8.0,

i create a new dataset and choose 3 tables for the dataset to include,

when i push "next" i get the error : "Java Heap space"

searched this forum and tried the solution suggested and nothing helped.

i tried changing the ireport.conf file values from :   -J-Xmx512m    to -J-Xmx1024m or even -J-Xmx2048m.    it doesn't change anything.

also checked "use visualizer" but i don't know what it is and how to work with it.  anyway, checking the "use visualizer" didn't solve the problem.

 

any more ideas ?

 

[Error:Java Heap Space]

Having the same problem with ireport 4.8.0

changing the ireport.conf file doesn't help , any solution for this?

[JAVA HEAP SPACE error]

i have the same error in 4.8.0.

none of the solutions above work.

any solution for this?

[using Group By in Ireport 4.8.0]

Thank you cjasper, trying to find information on it, is there any updated documentation of how to use group header and footer?

[using Group By in Ireport 4.8.0]

in Ireport 4.8.0

i want to create a report that shows the contacts in each "lead status".

i created a datasource with this query:

SELECT
     leads.`first_name` AS leads_first_name,
     leads.`last_name` AS leads_last_name,
     leads.`status` AS leads_status
FROM
     `leads` leads
GROUP BY
     leads_status

i expected that this query will show a seperate table for each lead status with all the contacts of this specific lead status,

but all i get is mini tables with all lead status together:

 

How do i create a seperate table for all contacts in each lead status?