runner1549

Is there an easy way to convert an existing "Tabular Layout" report to "Columnar Layout" ? Attached shows what displays when I first create a report.

Is there a way in JasperServer Community Edition to allow users to click on a Column Header to "Sort" by that column ? Screenshot attached.

I have a JasperServer's scheduled hourly "RO103" report that automatically emails me every hour ONLY if it has results. I got the below at 7pm, 8pm, and 9pm last night. I then manually ran the "RO103" report today and it displays "The report is empty", showing that there are no results. What is the "OALL8 is in an inconsistent state" ERROR below ? ** Maybe my Oracle db was down for a few hours and then recovered by 10pm since I did not get a 10pm "RO103" error report ? ------------------------------------------------------------------ com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : RO103 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:127) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1212) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:661) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:356) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:788) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:288) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:441) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:369) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLException: OALL8 is in an inconsistent state at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 17 more

Thanks, below are the steps I did: 1. drop "Frame" onto DESIGN band 2. Properties ** Left = 0 ** Position Type = Float ** Top = 60 ** Width = 555 3. drop "Non-Legal" StaticTextbox & fieldBox onto "Frame" 4. Properties ** Position Type = Float ** Top = 0 5. click on "Legal" fieldBox 6. Properties ** Stretch with Overflow = checked 7. works

Attached is the code (PV133.jrxml) and updated screenshot.

How can I get the "Detail" BAND to automatically resize "BAND HEIGHT" so the attached BLANKS don't appear ?

Doing the below "Solution" worked, but how can I resort the below so all "Yes" items display first ? Solution 1. drop "TextField" onto page 2. add ($F{USA}.equals($F{CANADA}) ? "No":(!$F{USA}.equals($F{CANADA}) ? "Yes":"Fail")) 3. make no changes to below SQL SELECT fmr.fmcode, MAX(DECODE(fma.fmpropertyid, 391, REPLACE(FMP.FMMINIMUM,' ',NULL))) usa, MAX(DECODE(fma.fmpropertyid, 19933, REPLACE(FMP.FMMINIMUM,' ',NULL))) canada FROM fmpropertyassign fma INNER JOIN fmpropasschar fmp ON fma.fmpropertyassignid = fmp.fmpropertyassignid INNER JOIN fmresource fmr ON fmr.fmentityobjectid = fma.fmentityobjectid WHERE fma.fmpropertyid IN (19933, 391) and fmr.FMENTITYID = 1 group by fmr.fmcode

What formula can I use to get the YELLOW results ? ** Display "no" since B2 and C2 columns are equal ** Display "yes" since B3 and C3 columns are not equal I use the below in EXCEL, but don't know what to use in iReports =if(B2=C2,"No","Yes")

I have the below PV123.jrxml logic working. If "nlf.NLGROUP" column is "1", then display "Checked" text, else display "Unchecked" text -------------------------------------------------------- SELECT fm.FMCODE, nl.NLTEXT, decode (nlf.NLGROUP, 1, 'Checked', 'Unchecked') Parenthetically FROM NLINGREDIENTSTATEMENT nl RIGHT OUTER JOIN FMFORMULA fm ON fm.FMENTITYOBJECTID = nl.FMFORMULAID RIGHT OUTER JOIN NLLABELNAMEFORMAT nlf ON nlf.FMENTITYOBJECTID = fm.FMENTITYOBJECTID where nl.NLREFLABELNAMEID = 1 -- USA ingredient labels and fm.FMENTITYID = 467 ORDER BY FMCODE -------------------------------------------------------- How can I change it so users have three options when running the report via JasperServer ? Option #1 --> check 1. user clicks "PV123" report 2. "Parenthetically" checkbox displays 3. user checks box 4. report runs, showing only items with "nlf.NLGROUP = 1" Option #2 --> uncheck 1. user clicks "PV123" report 2. "Parenthetically" checkbox displays 3. user does checks box 4. report runs, showing only items with "nlf.NLGROUP = 0" Option #3 --> all 1. user clicks "PV123" report 2. "Parenthetically" checkbox displays 3. user checks "ALL" (or something else) 4. report runs, showing ALL items

How can I force the attached "A1507" to display on page #2, disallowing part of the item to appear on page #1 and part on page #2 ? ------------------------------------------------ Failed Solution 1. open PV105.jrxml 2. click "FMCODE Group Header" ** Properties ** "Split allowed" = unchecked ** "Start on a new page" = unchecked ** checking this causes each item to appear on a new page, I want to still allow multiple items to appear on one page (if they fit) like the currently do 3. repeat for "Detail" and "FMCODE Group Header" 4. also do on PV105_SUB.jrxml subreport 5. compile into .JASPER files 6. run using "A15%" 7. still appears with "A1507" split onto two pages ------------------------------------------------ Possible Solution 1. do something with "Min Height To Start New Page" property ?

Thanks, below worked new Double(($V{COMP_PERC_1}!=null?$V{COMP_PERC_1}.doubleValue():0)+ ($V{CAT_PERC_1}!=null?$V{CAT_PERC_1}.doubleValue():0))[/code]

How can I get the below to work when one value is null ? ------------------------------------------------------------------------------------- Example 1. COMP_PERC_1 = 10 2. CAT_PERC_1 = NULL 3. below display NULL, but should really display "10" new Double($V{COMP_PERC_1}.doubleValue() + $V{CAT_PERC_1}.doubleValue())

Do you have an easier way to edit SQL code in iReport and get the benefits of TOAD's attached column prompting without having to do the below steps ? 1. create report 2. six months later get a request to change the report 3. open JRXML in iReport 4. open "Report Query" Window 5. copy below SQL into TOAD ================================================ select fmr.FMCODE COMPONENT, fmrc.FMPERCENTAGE * 100 PERC, nlln.NLTEXT, fmr.FMCAS, fmppc.FMMINIMUM ALLERGEN, fmP.fmcode PARENT from fmresource fmr inner join gml_cas gcas on fmr.FMCAS = gcas.CAS inner join nllabelname nlln on nlln.FMENTITYOBJECTID = fmr.FMENTITYOBJECTID inner join fmpropertyassign fmpa on fmpa.FMENTITYOBJECTID = fmr.FMENTITYOBJECTID inner join fmpropasschar fmppc on fmppc.FMPROPERTYASSIGNID = fmpa.FMPROPERTYASSIGNID inner join FMRESOURCECMP fmrc on fmrc.FMRESCOMPONENTID=fmr.FMENTITYOBJECTID inner join fmresource fmP on fmrc.fmresourceid = fmP.fmentityobjectid where fmpa.FMPROPERTYID = 391 and fmP.fmcode LIKE $P{FMCODE} --where fmpa.FMPROPERTYID = 391 and fmP.fmcode LIKE '%A1539%' and fmr.FMCAS = $P{FMCAS} --and fmr.FMCAS = 150 ================================================ 6. comment out $P... lines, uncomment value lines 7. tweak SQL in TOAD 8. run to make sure SQL works 9. uncomment $P... lines, comment out value lines 10. copy new SQL back into iReport

How can I allow user to click on one of the attached column headers to resort the report in ASC or DESC order ? Is this maybe only doable in the JasperServer non-Community edition ?

Thanks, they are doubles, so I did as follows: new Double($V{COMP_PERC_1}.doubleValue() + $V{CAT_PERC_1}.doubleValue())