sefas

I am trying to use the ORDER BY CASE sql statement in my report query to sort data in a specific order, but it does not like the syntax. In oracle the syntax is e.g. order by case when order_type = 12 then 1 when order_type = 10 then 2 else 3 end Any idea what the correct syntax is to do this in the Report query?.

I have eight sub reports and when the number of rows returned is large, I get a java heap space memory error. My report is written in ireports 3.00 and runs under the same Jasper reports engine. I do not get the error when it is run via the ireports development GUi, only when run via the backend engine. Is there anything I can do to configure the use of more java memory?

Edit the expression for the field on the report so that if the value is 2, you set the value to "Approved"

If you create a report parameter and tick "use as a prompt" it should prompt you

With a group I can specify the min height to Start New Page. How can I do these for the column header band? I want to ensure that whenever the group overflows to a new page, the column headers are printed.

OK, I found the solution...Edit..Report Proprties...More...Summary on new page

How can I force the summary band to print on a new page?

I am using iReports 3.0.0 I have created a BigDecimal variable COUNT_MISSING as below. I am trying to set it to 0 or 1 depending on the value of the variable $V{NOT_PROCESSED} (which is defioned as java.lang.Integer However the if condition in the variable expression always returns 1, even if $V{NOT_PROCESSED} is equal to 0 Any ideas? ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Code:<variable name="COUNT_MISSING" class="java.math.BigDecimal" resetType="Group" incrementType="Group" incrementGroup="LEVEL" resetGroup="INDATE" calculation="Sum"><variableExpression><![CDATA[($V{NOT_PROCESSED} == new java.lang.Integer(0) ) ? new java.math.BigDecimal(0) : new java.math.BigDecimal(1)]]></variableExpression><initialValueExpression><![CDATA[new java.math.BigDecimal(0)]]></initialValueExpression></variable>

Which jar files do I need to distribute to enable charts to work correctly? We are using vesrion 3.0.0. of jasper reports But wehen we run the report we get the following error : org/jfree/chart/plot/PlotOrientation]: java.lang.NoClassDefFoundError: org/jfree/chart/plot/PlotOrientation Post Edited by sefas at 01/15/2010 11:18

OK, thanks. Here is the relevent bit of my report query SQL AND submitted_date >= $P!{PARAM_TO_DATE} parameter PARAM_TO_DATE is defined as a java.util.date with the default Value Expression set to new java.util.Date("01/01/2050") But when the the Report query reads the SQL is gives the error Error : SQL problems: Missing IN or OUT parameter at index ::1 Post Edited by sefas at 11/12/2009 16:14

I have a report that I need to run against a variety of SQL databases, i.e Oracle, MYSQL, DB2 The report is passed a date/time parameter in a string format e.g. 2009111112235959 I need to use this in a select statement when querying the database, whether it be Oracle, MYSQL or whatever. Is there anyway to do this WITHOUT using database specific functions (such as TO_DATE for Oracle)?

What determines the default date format in the report query for Oracle in ireports? Is it set by the JDBC driver or somewhere else? Can I change it?

How can I initCap a string in an expression. I have tried new java.lang.String($F{MYFIELD}.initCaps()) But this causes a syntax error

I worked it out for myself. I had to delete the parameter, do a compile, recreate the parameter, do a compile, and then the report was OK

I am having a problem using a parameter in a report query. The query code is in the Code window below.. The issue is with the following bit of the query AND jobs.test = '$P!{TEST_PROD_TO_QUERY}' If I hardcode the select value for jobs.test in the query to 'PROD' i.e AND jobs.test = 'PROD' the report returns data. But If I replace the hard-coded value with a parameter which has the Default Value Expression set to "PROD", the report returns the error "document has no pages" Its driving me mad...any ideas? ireport version is 3.0.0 Code:select mailer_groups.description, mailers.mailer, mailers.mailer_group, mailers.make, mailers.model, mailers.specification_details, mailing_history.submitted_date, mailing_history.sequence, mailing_history.completed_date, mailing_history.submitted_operator, mailing_history.completed_operator, mailing_history.job_id, mailing_history.file_number, mailing_history.reprint_count, mailing_history.number_of_mailpieces, mailing_history.number_of_reprints, jobs.customer, jobs.department, jobs.document_type FROM mailers, mailer_groups, mailing_history, jobs WHERE mailing_history.mailer = mailers.mailer AND mailing_history.job_id = jobs.job_id AND mailer_groups.mailer_group = mailers.mailer_group AND (mailing_history.completed_date IS NOT NULL OR mailing_history.completed = 'Y') AND jobs.test = '$P!{TEST_PROD_TO_QUERY}' ORDER BY mailers.mailer_group asc, mailers.mailer asc, mailing_history.submitted_date asc, mailing_history.completed_date asc, mailing_history.job_id asc , mailing_history.file_number asc